Freeze and split panes in Excel |
Microsoft Office is one of the more popular programs, often found on systems regardless of the OS. For businesses one of the more useful Office programs is Excel. Excel has a near infinite number of uses. One problem with Excel is that it almost does too much, and some spreadsheets can become unwieldy. There are a few things you can do, however, to make entering and referencing data a bit easier. Here’s how you can easily keep track of your place in spreadsheets through the use of freezing and splitting panes. Freezing panes You can freeze both rows and columns by:
After you’ve frozen panes, you will notice that the Freeze Panes option has been changed to Unfreeze Panes. Pressing this will unfreeze the rows or columns you have previously frozen. The only issue with this is that you can only freeze rows or columns on the outer edge of the workbook, you cannot freeze panes in the middle of the workbook. Splitting panes You can split panes by:
This will create a vertical split. If you want to create a horizontal split pane, you can drag the split bar located beside the horizontal scrollbar – located in the bottom right beside the right-hand facing black arrow – to the area you would like to split. By either splitting or freezing panes, you can easily keep track of important cells while navigating to other parts of your spreadsheet. You should be aware however, that you can’t split and freeze panes at the same time. If you have split a pane, and then click on Freeze Panes, Excel will turn off the split pane, and freeze all rows and columns above and to the left of the start of the split pane. If you would like to learn more about how Excel and Microsoft’s other products can help you and your employees, please contact us, we can help. |
What exactly is server virtualization? |
One of the biggest tech trends of the past two years is the topic of virtualization. This is a wide ranging topic that covers issues such as digitizing aging phone systems, moving programs off of hard drives and into the cloud, as well as taking existing servers and creating digital counterparts that have many benefits to users. While virtualization is a buzzword, many users are still fairly unclear about virtualization especially in relation to servers. |
The great email debate: archive v delete |
Email is a complicated beast. While we all use it on a daily basis, many users don’t really stop to think about how it works or how it should work. One of the common ‘goals’ of email is to get your inbox to 0, with all messages read and dealt with in an organized way. Clearing out your inbox usually entails deleting lots of emails. However, one question is should you really be deleting email? |
Increase productivity with iPad and apps |
Tablets are gaining traction in businesses, many are starting to integrate them in some function. One of the more popular tablets is Apple’s iPad. One of the reasons people love it so much is largely because of the sheer amount of apps. Some of these help users increase their productivity, something that many businesses can benefit from. |
Copyright post on Facebook confuses |
Facebook is to some the greatest thing on earth, to others a necessity and to the rest a form of modern-day narcissism. While it’s been around for nearly nine years, many users have only been using it for the past five. Since then it’s become a place for people to share nearly everything about their lives, with many arguably sharing way too much. This sharing has led to a number of security updates from Facebook, and each time the Terms of Service is updated, users freak out, often sending chain letters or posting on their wall complaining about who owns what. |