Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Headers (or freezing rows) Gene L. New Users to Excel 3 March 30th 08 12:15 AM
**freezing rows ** zoom zoom Excel Discussion (Misc queries) 1 May 31st 07 09:56 PM
Freezing multiple rows/columns in Excel 2007 Pro gary Excel Worksheet Functions 3 May 2nd 07 07:17 AM
Freezing rows & columns Michael Excel Worksheet Functions 1 August 12th 05 04:00 AM
Freezing? Rows Ourania Excel Discussion (Misc queries) 2 January 18th 05 07:47 PM


All times are GMT +1. The time now is 05:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"