Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Freeze panes just splits my page into quadrants

when what I really want it to do is freeze the first column. How can I
change it?

  #2   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson
 
Posts: n/a
Default Freeze panes just splits my page into quadrants

Hi,
I think you should:
1. Unfreeze the panes
2. Select B1
3. Freeze the panes

If you want just column a frozen

Ken Johnson

  #3   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson
 
Posts: n/a
Default Freeze panes just splits my page into quadrants

Hi Joe,
Select B1 before freezing the panes.
Ken Johnson

  #4   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default Freeze panes just splits my page into quadrants

Hi!

Unfeeze panes, select cell B1, then try it again!

The panes will be frozen at the column to the left and the row above the
selected cell.

If you select cell B2, both column A and row 1 will be frozen.

Biff

wrote in message
oups.com...
when what I really want it to do is freeze the first column. How can I
change it?



  #5   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Freeze panes just splits my page into quadrants

Thanks all. Biff the B2 tip was excellent, thanks.



  #6   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default Freeze panes just splits my page into quadrants

You're welcome. Thanks for the feedback!

Biff

wrote in message
oups.com...
Thanks all. Biff the B2 tip was excellent, thanks.



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
Problem with Page Numbering Aurora Excel Discussion (Misc queries) 0 November 21st 05 02:10 PM
Page Numbers Aurora Excel Discussion (Misc queries) 0 November 17th 05 08:04 PM
How do i use multiple splits or frozen panes? Pat Excel Discussion (Misc queries) 2 November 14th 05 09:52 PM
Excel should have a second 'Freeze Panes' option that works in re. -JEFF- Excel Discussion (Misc queries) 0 August 12th 05 08:27 PM
Shared File & Freeze panes issue JM Excel Discussion (Misc queries) 0 January 21st 05 07:01 PM


All times are GMT +1. The time now is 09:50 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"