Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In earlier versions, you clicked below the rows you wanted frozen in place or
to the right of the rows you wanted frozen. Now I see only how to freeze row 1. I have a main title in row 1, row 2 is blank and row 3 has column headings, so I want row 3 to stay frozen in place. I am having trouble accomplishing this and need help, please. Thank you. -- Virgo |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Select cell A4. and try freeze pans..
-- Jacob "Virgo" wrote: In earlier versions, you clicked below the rows you wanted frozen in place or to the right of the rows you wanted frozen. Now I see only how to freeze row 1. I have a main title in row 1, row 2 is blank and row 3 has column headings, so I want row 3 to stay frozen in place. I am having trouble accomplishing this and need help, please. Thank you. -- Virgo |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The freezing rule is...........
Anything above and to the left of your selected cell is frozen when you freeze panes. ViewFreeze Panesda da da(based on current selection) So............. A4 and freeze panes will freeze rows 1 to 3 B4 will freeze rows 1 to 3 and column A Gord Dibben MS Excel MVP On Fri, 19 Feb 2010 11:03:03 -0800, Virgo wrote: In earlier versions, you clicked below the rows you wanted frozen in place or to the right of the rows you wanted frozen. Now I see only how to freeze row 1. I have a main title in row 1, row 2 is blank and row 3 has column headings, so I want row 3 to stay frozen in place. I am having trouble accomplishing this and need help, please. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Headers (or freezing rows) | New Users to Excel | |||
**freezing rows ** | Excel Discussion (Misc queries) | |||
Freezing multiple rows/columns in Excel 2007 Pro | Excel Worksheet Functions | |||
Freezing rows & columns | Excel Worksheet Functions | |||
Freezing? Rows | Excel Discussion (Misc queries) |