Multiple "Freeze Panes" one one worksheet

  • Thread starter Frustrated Word User
  • Start date

F

Frustrated Word User

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

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

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

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

Please let me know. I truly appreciate any advice

Best regards
Joann

(Frustrated Word (& Excel) User
 
Ad

Advertisements

D

Dave Peterson

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.
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)
 
Ad

Advertisements

F

Frustrated Word User

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

I appreciate your advice.

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

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

When you're done, you can select the window you don't want and hi
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 pane
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top