Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code to prevent Remove Split or Unfreeze Panes? | Excel Discussion (Misc queries) | |||
Disable Unfreeze Panes and Remove Split, how? | Excel Discussion (Misc queries) | |||
More Dividers for Excel Viewing Panes / multiple panes per axis. | Excel Discussion (Misc queries) | |||
Freeze and split panes in Excel 2003 | Excel Worksheet Functions | |||
Excel should allow independent zoom adjustment of split panes | Excel Discussion (Misc queries) |