![]() |
Help freezing multiple top rows
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 |
Help freezing multiple top rows
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 |
Help freezing multiple top rows
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. |
All times are GMT +1. The time now is 03:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com