User not logged in - login - register
Home Calendar Books School Tool Photo Gallery Message Boards Users Statistics Advertise Site Info
go to bottom | |
 Message Boards » » quick MS Excel question (Excel 07) Page [1]  
TreeTwista10
minisoldr
148585 Posts
user info
edit post

I have a spreadsheet that I update daily...the first column is the date, and every cell as you go down that column is basically the next day...at the top I have a number of column headings

How do I make it so whenever I scroll down to a various date, the column headings are always displayed?

Thanks.

12/18/2009 6:56:37 PM

ryan627
Veteran
333 Posts
user info
edit post

1) Go to the "View" tab

2) Click "Freeze Panes"

3) Click "Freeze Top Row"

Does that do it?

12/18/2009 7:00:01 PM

TreeTwista10
minisoldr
148585 Posts
user info
edit post

Hell yeah man, gracias

I actually needed to freeze the top 4 rows, but I just highlighted the 5th row and went to 'Freeze Panes' and it froze the top 4

[Edited on December 18, 2009 at 7:04 PM. Reason : .]

12/18/2009 7:02:28 PM

 Message Boards » Tech Talk » quick MS Excel question (Excel 07) Page [1]  
go to top | |
Admin Options : move topic | lock topic

© 2024 by The Wolf Web - All Rights Reserved.
The material located at this site is not endorsed, sponsored or provided by or on behalf of North Carolina State University.
Powered by CrazyWeb v2.39 - our disclaimer.