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


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,480
Default 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


  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 14
Default 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.
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
Code to prevent Remove Split or Unfreeze Panes? dk_ Excel Discussion (Misc queries) 6 October 9th 06 08:35 PM
Disable Unfreeze Panes and Remove Split, how? dk_ Excel Discussion (Misc queries) 2 October 4th 06 10:57 PM
More Dividers for Excel Viewing Panes / multiple panes per axis. bIgJeNkS3 Excel Discussion (Misc queries) 1 August 2nd 06 11:51 PM
Freeze and split panes in Excel 2003 John Excel Worksheet Functions 2 January 31st 06 10:43 PM
Excel should allow independent zoom adjustment of split panes One Excel User Excel Discussion (Misc queries) 5 January 12th 05 12:14 AM


All times are GMT +1. The time now is 09:32 PM.

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

About Us

"It's about Microsoft Excel"