Freeze Vertical and Horizontal

[rayybay]

How would I freeze panes (or something similar) so that when I scroll down, I
still see my header row, AND when I scroll right, I can see my other header
row. i.e. I have Dates across the top and Descriptions down the left. I
need to see those two things at all times. Any suggestions? Thanks!

 

[Lars-Åke Aspelin]

How would I freeze panes (or something similar) so that when I scroll down, I
still see my header row, AND when I scroll right, I can see my other header
row. i.e. I have Dates across the top and Descriptions down the left. I
need to see those two things at all times. Any suggestions? Thanks!

Select the first cell that you want to scroll and the click on Freeze
panes in the View menu (or in the Window section of the View bar if
you use Excel 2007)

Hope this helps / Lars-Åke

 

[Gord Dibben]

Select B2 and Window>Freeze Panes.

The freezing rule is.................everything left of and above the
selected cell will be frozen.


Gord Dibben MS Excel MVP

 

[rayybay]

Thank you SO much...sometimes the simplest things can drive me crazy!!!

 

[Senzo]

select and click the cell in between the the header row you want to see when
you scroll down and the headers you want to see on your on your left.Select
window on the menu bar and split cells,then now you can freeze panes.