ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   multiple split screen (https://www.excelbanter.com/excel-programming/317701-multiple-split-screen.html)

DSK_7

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

Stephen Knapp

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


DSK_7[_2_]

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



All times are GMT +1. The time now is 06:45 PM.

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