Do you want to be able to always see the headings of your columns whilst you scroll through your Excel 2007 spreadsheet?
To do that, you need to “Freeze” the top row of your sheet.
To Freeze the top row in Excel 2007:
1) Click on the “View” tab of the ribbon
2) Look for the “Window” group
3) Click on “Freeze Panes”
4) Click on “Freeze Top Row”
To unfreeze the top row, just repeat the process above, but instead of clicking “Freeze Top Row” in step 4), just click on “Unfreeze Panes”
‘till next time! TNP
Help, Tips, Tricks, and Tutorials for Word, Excel, Outlook, Office 365 and more
Copyright 2006-2013 Paul Woods. All rights reserved. Proudly powered by WordPress. TheNewPaperclip.com V3 theme based on Fresh Editorial by BrightCherry.
Office 2007 and Office 2010 Help, Tips and Tutorials hosted by Dreamhost.For more web, email, collaboration, CRM, contact center and voice hosting options - visit www.hostedoptions.com