how do i split an excel spreadsheet into 6 panes?

[Baigi]

hello,
first of all i would like to say thanks to all of you out there who are
actualy trying to help me with this.
in excel 2003 we have option to split spreedsheet into four my going
Window>Split but my question is if i want to split that into 6 or more, how
can i do that. any help will be greatly appreciated.

baigi

 

[Roger Govier]

Hi

There are only two screen splitters, one horizontal and one vertical so you
can only have 4 panes.
You could use those to create 4 panes, where the right 2 panes are twice as
wide as the left panes.
Then perhaps, use the Camera tool to show two other parts of the sheet,
taking up the right hand side of the 2 larger panes.

 

[Gord Dibben]

You can create 6 windows with a different view in each window.

Window>New Window 5 times.

Then arrange as you like.


Gord Dibben MS Excel MVP

 

[Roger Govier]

Much easier solution, Gord

 

[BIG D]

Hi

There are only two screen splitters, one horizontal and one vertical so you
can only have 4 panes.
You could use those to create 4 panes, where the right 2 panes are twice as
wide as the left panes.
Then perhaps, use the Camera tool to show two other parts of the sheet,
taking up the right hand side of the 2 larger panes.

--
Regards
Roger Govier







- Show quoted text -

You could also open another window "Window--New Window" then have to
the 2 windows arranged in whichever style suits you but that may get a
little busy for the eyes.