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.
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.
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]HIS
"Tovarish_Dad" <[email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks