A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Multiple "Freeze Panes" one one worksheet



 
 
Thread Tools Display Modes
  #1  
Old November 3rd, 2009, 11:33 PM
Frustrated Word User Frustrated Word User is offline
Experienced Member
 
First recorded activity by OfficeFrustration: Apr 2008
Posts: 34
Smile Multiple "Freeze Panes" one one worksheet

Greetings All! [Title is supposed to read 'Multiple "Freeze Panes" on one worksheet'

Is it possible in Excel 2003 to freeze the panes of certain groups of cells within one worksheet?

For example: If I want to have four sections (for instance: cells A4-F4 by A4-A24(F24)) Four square sets of cells on one worksheet. I want each of these to contain a split 1/2 way down, where the panes are frozen.

Is this possible? So far I have not found a way.

Please let me know. I truly appreciate any advice.

Best regards,
Joanna

(Frustrated Word (& Excel) User)
__________________
aka: Frustrated Excel User

Thank you for your help.

Last edited by Frustrated Word User : November 3rd, 2009 at 11:34 PM. Reason: spelling error
  #2  
Old November 4th, 2009, 03:09 PM posted to microsoft.public.excel.setup
Dave Peterson
external usenet poster
 
Posts: 19,791
Default Multiple "Freeze Panes" one one worksheet

You get one freeze panes (or split) per window.

But maybe you could use window|new window and arrange them the way you like.

When you're done, you can select the window you don't want and hit ctrl-w to
close it.

Frustrated Word User wrote:

Greetings All! [Title is supposed to read 'Multiple "Freeze Panes" on
one worksheet'

Is it possible in Excel 2003 to freeze the panes of certain groups of
cells within one worksheet?

For example: If I want to have four sections (for instance: cells
A4-F4 by A4-A24(F24)) Four square sets of cells on one worksheet. I
want each of these to contain a split 1/2 way down, where the panes are
frozen.

Is this possible? So far I have not found a way.

Please let me know. I truly appreciate any advice.

Best regards,
Joanna

(Frustrated Word (& Excel) User)

--
Frustrated Word User


--

Dave Peterson
  #3  
Old November 6th, 2009, 03:34 PM
Frustrated Word User Frustrated Word User is offline
Experienced Member
 
First recorded activity by OfficeFrustration: Apr 2008
Posts: 34
Wink

Thanks Dave, I just ended up creating buttons and writing show and hide macros in the same worksheet.

I appreciate your advice.

TGIF!!

Quote:
Originally Posted by Dave Peterson View Post
You get one freeze panes (or split) per window.

But maybe you could use window|new window and arrange them the way you like.

When you're done, you can select the window you don't want and hit ctrl-w to
close it.

Frustrated Word User wrote:

Greetings All! [Title is supposed to read 'Multiple "Freeze Panes" on
one worksheet'

Is it possible in Excel 2003 to freeze the panes of certain groups of
cells within one worksheet?

For example: If I want to have four sections (for instance: cells
A4-F4 by A4-A24(F24)) Four square sets of cells on one worksheet. I
want each of these to contain a split 1/2 way down, where the panes are
frozen.

Is this possible? So far I have not found a way.

Please let me know. I truly appreciate any advice.

Best regards,
Joanna

(Frustrated Word (& Excel) User)

--
Frustrated Word User


--

Dave Peterson
__________________
aka: Frustrated Excel User

Thank you for your help.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:53 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.