Freeze Vertical and Horizontal
 

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!

Freeze Vertical and Horizontal
 

On Fri, 1 Aug 2008 15:36:07 -0700, rayybay
wrote:

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

Freeze Vertical and Horizontal
 

Select B2 and WindowFreeze Panes.

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


Gord Dibben MS Excel MVP

On Fri, 1 Aug 2008 15:36:07 -0700, rayybay
wrote:

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!

Freeze Vertical and Horizontal
 

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

"Gord Dibben" wrote:

Select B2 and WindowFreeze Panes.

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


Gord Dibben MS Excel MVP

On Fri, 1 Aug 2008 15:36:07 -0700, rayybay
wrote:

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!

Freeze Vertical and Horizontal
 

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.

"rayybay" wrote:

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!