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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
(e-mail address removed)
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Multiple workbook sheets into one workbook 0
how do I arrange multiple worksheets from the same workbook 2
Excel should allow you to tile sheets within a workbook. 2
Excel Worksheet Tabs 4
View worksheets simultaneously 1
Trace links between worksheets within one workbook 4
Sharing workbooks limitations - Merged Cells 12
consolidate workbooks to worksheets in one workbook? 1

Back
Top