Excel column headers [Archive] - Glock Talk

PDA

View Full Version : Excel column headers


volky
11-21-2010, 20:39
I did this once, but have since forgotten. How do you keep the column headings on top, visible when you scroll down the columns ?

This time I'll write it down, I promise.

econjon
11-21-2010, 20:48
Assuming the column headers are in row #1, you'll want to highlight row 2 (the one below the one with the headers) and hit 'freeze panes'. In 2003 this is an option under the "window' tab at the top of the spreadsheet or in 2007 I think it's under the "view" tab.

BobbyT
11-21-2010, 20:51
I don't have Excel on this computer, just OpenOffice, but on the left if you click the Row number where your headings are (or maybe the one below; fiddle with it), it should highlight that whole row.

Then under Data I believe there's a "Freeze Cells" option. Once you freeze them, they won't scroll with the rest of the data below.

But this is off the top of my head, so you may have to check the sub menus.

MavsX
11-22-2010, 07:34
econjon ftw