When you’re working on an expansive spreadsheet that is getting out of hand, it can be frustrating when you scroll through a table, lose sight of the horizontal or vertical label and no longer know which entry you’re looking at.
That’s where freeze panes come to the rescue! Setting up freeze panes allows you to keep the horizontal and vertical labels ‘frozen’ on the page so that when scrolling you don’t lose site of important data.
Using freeze panes is incredibly easy on modern versions of Microsoft Excel, there’s a button that allows you to freeze and unfreeze in two clicks. You can find the button under the ‘View’ tab, in the ‘Window Section’ – helpfully called ‘Freeze Panes’.
Clicking the button brings up three options:
- Freeze Panes
- Freeze Top Row
- Freeze First Column
The second two options are self explanatory. They’re the simplest it you only want the top row or first column frozen. However you may want to freeze both at once, or more than one column. To do this you use the top option. Clicking ‘Freeze Panes’ freezes everything above and to the left of the cell you’ve highlighted. So if you want the top row and left column, select cell B2 and click Freeze Panes. Here are some other combinations to help you figure out which cell to select: Read the rest of “How to Freeze Panes in Microsoft Excel”
With finances being tighter than normal through 2011, New Years parties could quite easily be the straw that broke the financial advisor’s back. Extra effort needs to be made to maximise the resources. You have to minimise costs, and what way would be better that using Excel as an all in one New Years Eve Party Planner.
With so many things to keep in mind over the festive period why not organise all of your guest list, budget and most impotently shopping lists into separate sheets within a workbook, topping it off with a fancy coversheet. Here are some tips for making your own:
What to Plan?
First off, you need to work out what you want to keep a record of. You may want to make a note of things such as:
- Guest list
- Decoration list
- Alcohol / Food shopping list
Each of these will be recorded on their own sheet, so make sure you insert extra sheets (in Excel 2007 press Shift + F11) to account for each topic you want to make note of, as well as one extra sheet where you can make a fancy coversheet for easier navigation.
Do you need more formulae to really maximise your planning sheet? Then check this post out giving you our top 10 time saving excel formula.
Rename each of these sheets (labelled Sheet1, Sheet2 etc as default) to the relevant name of the topic you want to record in that sheet.
Read the rest of “Planning a New Years Spread(sheet)”
Microsoft have announced updates for their Office Web Apps based on feedback from users. Microsoft Excel Web App is one of the web based Office Apps available free to Hotmail users allowing you to create, access, edit and share documents anywhere with an internet connection and a browser. For full details on how to use Excel Web Apps and why they are useful read our previous post Excel Web App in Office 365. Office Web Apps are the free alternatives to Office 365 which has a monthly fee.
Microsoft Office Web Apps have faced criticism for lacking the features of Google Docs. This update addresses some of the issues associated with Excel Web App that regular Excel users have been asking for. Microsoft have had a year to listen to feedback since the launch of Office Web Apps and so this update should reflect what users have missed.
Excel Web App – New Features
Merge and Autofit Cells in Excel Web App
There have been two useful additions to cell formatting in the update – Merge and Autofit. To Merge Cells simply highlight the cells you want to merge and click the button: Read the rest of “Microsoft Announces New Features for Excel Web App”