ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help freezing multiple top rows (https://www.excelbanter.com/excel-discussion-misc-queries/256823-help-freezing-multiple-top-rows.html)

Virgo

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

Jacob Skaria

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


Gord Dibben

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