Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Freezing a row
Say I want to freeze a row in the middle of the sheet, Line above go away and
the lines below scroll, is ther a way. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Freezing a row
Hi Heidi
Let say you want to freeze row 55, scroll up till row 55 is at the top of your page, Click on row number 55 on the extreme left to highlight the row, then goto Window Freeze Panes. HTH John "Heidi" wrote in message ... Say I want to freeze a row in the middle of the sheet, Line above go away and the lines below scroll, is ther a way. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Freezing a row
Yes but then I'm also stuck with 1-55 being at the top and all I want frozen
is 55. "John" wrote: Hi Heidi Let say you want to freeze row 55, scroll up till row 55 is at the top of your page, Click on row number 55 on the extreme left to highlight the row, then goto Window Freeze Panes. HTH John "Heidi" wrote in message ... Say I want to freeze a row in the middle of the sheet, Line above go away and the lines below scroll, is ther a way. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Freezing a row
HI Heidi
You can't freeze just row 55 but try using Split instead of Freeze. Select row 56, leave it in the middle of the page,goto WindowSplit. You can move the split bar anywhere you like. This will give you two window to work with. HTH John "Heidi" wrote in message ... Yes but then I'm also stuck with 1-55 being at the top and all I want frozen is 55. "John" wrote: Hi Heidi Let say you want to freeze row 55, scroll up till row 55 is at the top of your page, Click on row number 55 on the extreme left to highlight the row, then goto Window Freeze Panes. HTH John "Heidi" wrote in message ... Say I want to freeze a row in the middle of the sheet, Line above go away and the lines below scroll, is ther a way. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Freezing Panes | New Users to Excel | |||
Freezing | New Users to Excel | |||
Freezing on SumIf | Excel Discussion (Misc queries) | |||
Help! Excel keeps freezing | Excel Discussion (Misc queries) | |||
freezing a row | Setting up and Configuration of Excel |