how do i split an excel spreadsheet into 6 panes?
 

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
WindowSplit 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

how do i split an excel spreadsheet into 6 panes?
 

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

"Baigi" wrote in message
...
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
WindowSplit 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

how do i split an excel spreadsheet into 6 panes?
 

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

WindowNew Window 5 times.

Then arrange as you like.


Gord Dibben MS Excel MVP

On Wed, 13 Feb 2008 09:19:01 -0800, Baigi
wrote:

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
WindowSplit 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

how do i split an excel spreadsheet into 6 panes?
 

Much easier solution, Gord

--
Regards
Roger Govier

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
You can create 6 windows with a different view in each window.

WindowNew Window 5 times.

Then arrange as you like.


Gord Dibben MS Excel MVP

On Wed, 13 Feb 2008 09:19:01 -0800, Baigi

wrote:

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
WindowSplit 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

how do i split an excel spreadsheet into 6 panes?
 

On Feb 13, 11:25*am, "Roger Govier"
<roger@technology4unospamdotcodotuk wrote:
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

"Baigi" wrote in message

...



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
WindowSplit 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- Hide quoted text -

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