Home Forums Classifieds GT Store Blogs Today's Posts Search Social Groups


Glock Talk
Welcome To The Glock Talk Forums.

Thread Tools Display Modes
Old 11-21-2010, 20:39   #1
NRA Member
volky's Avatar
Join Date: Aug 1999
Location: Take a seat facing the door.
Posts: 2,200

Excel column headers

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.
Don`t let anyone rent space in your head.
I can only please one person a day. TODAY ISN'T YOUR DAY. Tomorrow's not looking good either.
volky is offline   Reply With Quote
Old 11-21-2010, 20:48   #2
Senior Member
econjon's Avatar
Join Date: Aug 2004
Location: OUC
Posts: 444
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.
econjon is offline   Reply With Quote
Old 11-21-2010, 20:51   #3
Senior Member
Join Date: Jul 2008
Posts: 1,814
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.

Last edited by BobbyT; 11-21-2010 at 20:51.. Reason: Beaten to the punch...
BobbyT is offline   Reply With Quote
Old 11-22-2010, 07:34   #4
The Dude Abides
MavsX's Avatar
Join Date: Jan 2009
Location: Arlington, VA
Posts: 3,033
econjon ftw
Glock 22 .40 S&W
Mossberg 500 Mariner
MavsX is offline   Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -6. The time now is 10:14.

GT Wiki
GT Blogs
Social Groups
GT Store

Users Currently Online: 972
289 Members
683 Guests

Most users ever online: 4,867
May 19, 2015 at 1:03