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 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: 14
Default 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

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

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


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
Help freezing multiple top rows Virgo Excel Discussion (Misc queries) 2 February 19th 10 09:02 PM
**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 and columns Michael Excel Worksheet Functions 2 August 12th 05 04:02 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:17 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"