Fix the top row of your Spreadsheet
18th April 2010
... Comments

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 and click on the tips page.



About the Author

Shelley F

Member since: 6th January 2011

Shelley Fishel is the Founder and Managing Director of The Training Surgery, an IT training company that focuses on the needs of the clients. Training in your office, with your documents focussed on your...

Popular Categories