ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   splitting panes in excel (https://www.excelbanter.com/excel-discussion-misc-queries/62877-splitting-panes-excel.html)

maacmaac

splitting panes in excel
 

Is there a way to split Excel panes into 3 or more panes. I am able to
split into two panes, but would like to see 3.

Thanks for any comments.


--
maacmaac
------------------------------------------------------------------------
maacmaac's Profile: http://www.excelforum.com/member.php...fo&userid=2959
View this thread: http://www.excelforum.com/showthread...hreadid=497681


wjohnson

splitting panes in excel
 

On the TOOL BAR - got to WINDOW - Select NEW WINDOW - Then Select NEW
WINDOW, (this will give you 3 Windows, for 4 just Select NEW WINDOW
Again. Then on the TOOL BAR - Select WINDOW - Then Select ARRANGE -
Then select Horizontal or Vertical.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=497681


Ken Johnson

splitting panes in excel
 
Hi maacmaac,
A window can only have 1, 2 or 4 panes.
1 when panes are not frozen, 2 when panes are frozen after selecting a
column A cell or a row 1 cell, and 4 when panes are frozen after
selecting any cell not in column A or row 1.
Ken Johnson



All times are GMT +1. The time now is 05:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com