ExcelBanter

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

Virgo

Help Freezing Multiple 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

Toothsome Papa

Help Freezing Multiple Rows
 
click on cell A4 then on the menu bar Window/Freeze Panes

"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


Virgo

Help Freezing Multiple Rows
 
Sorry, this is 2007. I did click A4, View and Freeze, but it only freezes
row 1 :(

--
Virgo


"Toothsome Papa" wrote:

click on cell A4 then on the menu bar Window/Freeze Panes

"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 Rows
 
See replies to your other posting.

No need to multi-post.

Just wastes time and effort of those trying to help you.


Gord Dibben MS Excel MVP

On Fri, 19 Feb 2010 12:42:01 -0800, Virgo
wrote:

Sorry, this is 2007. I did click A4, View and Freeze, but it only freezes
row 1 :(




All times are GMT +1. The time now is 06:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com