Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Pane row and column freeze

The help manual seems to suggest that both rows and columns can be frozen. I
dont seem to be able to accomplish this.
What I want is to have rows 1 thru 4 to remain visable and columns a and b
to also not move down when I scroll down. I have placed my curson at the c5
cell and selected freeze pane. the top 4 rows are always visable but columns
A and B scroll up with the balance of the worksheet. I am using Office 2007
ultimate edition.
Any help or ideas???
Dean

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 320
Default Pane row and column freeze

If you freeze panes at C5, you will always see rows 1:4 and also A1:B4
(because they're in rows 1:4). However, A5 & beyond will scroll when you
scroll below row 4. You can't have what you describe. You can't see A5 while
looking at H200 if it's split as you want. You might try using View/New
Window & arranging the windows and you can then scroll totally
independently. You might even do View/New Window several times & arrange
them. Playing with that setting will enable you to see what you want, I
think. Once you've done New Window, tho, don't save your workbook with the
new windows or you'll always see these windows -- close the windows by the
"x" in the upper right until there's only one window left.
Bob Umlas
Excel MVP

"Dean475" <Dean in wrote in message
...
The help manual seems to suggest that both rows and columns can be frozen.
I
dont seem to be able to accomplish this.
What I want is to have rows 1 thru 4 to remain visable and columns a and b
to also not move down when I scroll down. I have placed my curson at the
c5
cell and selected freeze pane. the top 4 rows are always visable but
columns
A and B scroll up with the balance of the worksheet. I am using Office
2007
ultimate edition.
Any help or ideas???
Dean



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
freeze pane: freeze from two worksheets? Chris Excel Discussion (Misc queries) 4 May 27th 08 01:17 AM
How can I print the column headers in a freeze pane on all pag Meenie Excel Discussion (Misc queries) 0 January 16th 07 08:14 PM
Comments in freeze pane column jimt Excel Discussion (Misc queries) 0 January 15th 07 08:49 PM
Freeze pane Marisa Excel Worksheet Functions 3 January 11th 06 11:52 AM
In Excel allow freeze pane in any column plus any row vlado Excel Worksheet Functions 1 October 11th 05 05:00 PM


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