MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Headings of Columns/Rows


Posted by Bella on December 27, 2001 11:33 AM

I know this is a really simple question, but I'm pretty much a beginner Excel user. I've got a worksheet that's pretty large, and I'd like to be able to see the "title" rows and columns running along the top and left-hand side of the sheet. Is there some sort of freeze option so that I can still see these title rows while scrolling down or across?


Posted by Scott on December 27, 2001 11:38 AM

Windows-Freeze Panes

This will freeze everything above and to the left of the selected cell.

Posted by Joe Was on December 27, 2001 11:41 AM

Put your cursor on the line below the rows that have your lables, then select Window from the toolbar, the select Freeze Panes. Now when you scrol your titles will stay at the top. To cancel repeat but select unfreeze panes. JSW

Posted by Les on December 27, 2001 11:49 AM


-Your headings are in row 4
-Click on row number '5' to select the entire row
-Click <Window><Freeze Panes>.
-Use your arrows keys to scroll down, you will see your headings 'frozen'.

Do the same for row headings, but click on the letter (i.e."B") of the column to the right of the column that contains your headings.

There may well be a way to do this for both rows and columns at the same time, but I am unaware of it.

Posted by Scott on December 27, 2001 11:54 AM

If you just select a Cell, and choose Windows-Freeze Panes it will freeze everything above and to the left of the selected cell; both rows and columns. Windows-Unfreeze Panes to reset to normal.