Fix the top row of your Spreadsheet
Have you ever needed to fix the top row of your spreadsheet? You know what I mean? You have a large spreadsheet with lots of data and as you scroll down the sheet rows, the headings disappear. It is very frustrating!
Well with Excel you can fix the top row and even the left most column. It is called Freeze Panes.
To find out how to do this select the tip for the version of Excel that you are using.
Freeze Panes in Excel 2007 and 2003 (Windows)
Freeze Panes in Excel 2008 (Mac)
For more handy tips in Microsoft Office visit www.thetrainingsurgery.co.uk and click on the tips page.
Enjoy
Shelley
