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.

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

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