Can I tile worksheets within a workbook, like one tiles workbooks.

T

Tovarish_Dad

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.
 
N

Nick Hodge

Window>New 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
[email protected]
 
D

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.
 
Top