Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple split screen
Is it possible to have multiple split screens?
I work with huge spreadsheets and I constantly need to view different parts of the spreadsheet at the same time. Ideally, I'd like to be able to view 3-4 vertical sections (meaning, having 2-3 vertical splits). My band aid solution is to continuously group and ungroup the sections I need - but I realize this is not an elegant solution. Any suggestions. Thanks, DSK |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple split screen
That's easy. Click Windows, Arrange, New Window. This will open a
second view (or as many as you want) of the same spreadsheet (watch the title bar of each window and you'll see .1 or .2 behind the name). You navigate each window independently and can copy/paste at will, across the windows. Shut each one down when finished. Steve in Ohio "DSK_7" wrote: Is it possible to have multiple split screens? I work with huge spreadsheets and I constantly need to view different parts of the spreadsheet at the same time. Ideally, I'd like to be able to view 3-4 vertical sections (meaning, having 2-3 vertical splits). My band aid solution is to continuously group and ungroup the sections I need - but I realize this is not an elegant solution. Any suggestions. Thanks, DSK |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple split screen
Thanks, Stephen.
This partially solves my viewing problem. Reason I say partially is that unfortunately the other views don't scroll simultaneously when I scroll down in one window, for example. But anyway, it is an improvement to my earlier method. Cheers, DSK "Stephen Knapp" wrote: That's easy. Click Windows, Arrange, New Window. This will open a second view (or as many as you want) of the same spreadsheet (watch the title bar of each window and you'll see .1 or .2 behind the name). You navigate each window independently and can copy/paste at will, across the windows. Shut each one down when finished. Steve in Ohio "DSK_7" wrote: Is it possible to have multiple split screens? I work with huge spreadsheets and I constantly need to view different parts of the spreadsheet at the same time. Ideally, I'd like to be able to view 3-4 vertical sections (meaning, having 2-3 vertical splits). My band aid solution is to continuously group and ungroup the sections I need - but I realize this is not an elegant solution. Any suggestions. Thanks, DSK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split screen | Excel Discussion (Misc queries) | |||
How to split the spreadsheet, not the screen | Excel Discussion (Misc queries) | |||
Split screen | Excel Worksheet Functions | |||
split screen | Excel Discussion (Misc queries) | |||
Split Screen | Excel Worksheet Functions |