GlockTalk.com
Home Forums Classifieds Blogs Today's Posts Search Social Groups



  
SIGN-UP
Notices

Glock Talk
Welcome To The Glock Talk Forums.

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


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
econjon
Senior Member
 
econjon's Avatar
 
Join Date: Aug 2004
Location: OUC
Posts: 440
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
BobbyT
Senior Member
 
Join Date: Jul 2008
Posts: 1,787
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
MavsX
The Dude Abides
 
MavsX's Avatar
 
Join Date: Jan 2009
Location: Arlington, VA
Posts: 3,033
econjon ftw
__________________
Glock 22 .40 S&W
CMMG M4 LEP II
Mossberg 500 Mariner
MavsX is offline   Reply With Quote

 
  
Reply

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 15:22.




Homepage
FAQ
Forums
Calendar
Advertise
Gallery
GT Wiki
GT Blogs
Social Groups
Classifieds


Users Currently Online: 1,343
336 Members
1,007 Guests

Most users ever online: 2,244
Nov 11, 2013 at 16:42