ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I tile worksheets within a workbook, like one tiles workbooks. (https://www.excelbanter.com/excel-discussion-misc-queries/34106-can-i-tile-worksheets-within-workbook-like-one-tiles-workbooks.html)

Tovarish_Dad

Can I tile worksheets within a workbook, like one tiles workbooks.
 
It would often be very convenient to have two or more sheets from the same
workbook displayed at the same time (tiled). One can do this with workbooks,
but I cant seem to find a way to do it with worksheets within a workbook.

Nick Hodge

WindowNew window. Tile these and one set up with one sheet and one
another. Two views of the same file.

To close, close one window with the 'close' button, maximise the remaining
one and save

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Tovarish_Dad" wrote in message
...
It would often be very convenient to have two or more sheets from the same
workbook displayed at the same time (tiled). One can do this with
workbooks,
but I cant seem to find a way to do it with worksheets within a workbook.




Dave Peterson

Just to add to Nick's reply...

When you do window|arrange, make sure you check that "windows of active
workbook" checkbox (well, if that's what you want).

And I use this to close the windows I don't want:
ctrl-w (the activewindow will close).

I find it easier than looking for the correct X.

Tovarish_Dad wrote:

It would often be very convenient to have two or more sheets from the same
workbook displayed at the same time (tiled). One can do this with workbooks,
but I cant seem to find a way to do it with worksheets within a workbook.


--

Dave Peterson


All times are GMT +1. The time now is 12:51 PM.

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