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




--
Frustrated Word User
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 35,218
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   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 1
Default Multiple "Freeze Panes" one one worksheet


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

I appreciate your advice.

TGIF!!

Dave Peterson;3540971 Wrote:
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





--
Frustrated Word User
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
Printing "Freeze Panes" sh2195 Excel Worksheet Functions 3 April 11th 12 10:31 PM
Print "freeze panes" on succeeding pages? kdhelm Excel Discussion (Misc queries) 8 October 10th 08 12:38 AM
I want to lock row 1 in Excel. Why is "Freeze Panes" grayed out? Fran Z Excel Discussion (Misc queries) 2 January 15th 08 05:46 PM
Excel loses "Freeze Panes" setting Eric Excel Discussion (Misc queries) 1 November 3rd 06 12:21 AM
freeze window creates multiple "views" suffixed with ":n" dgaex001 Excel Discussion (Misc queries) 5 March 22nd 06 05:28 PM


All times are GMT +1. The time now is 04:03 AM.

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

About Us

"It's about Microsoft Excel"