Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vertical to Horizontal | Excel Discussion (Misc queries) | |||
Arrays - Horizontal or Vertical | Excel Worksheet Functions | |||
freeze horizontal and vertical panes at the same time in Excel | Excel Worksheet Functions | |||
Vertical to horizontal | Excel Discussion (Misc queries) | |||
how do i freeze a vertical column & horizontal row in excel? | Excel Discussion (Misc queries) |