Opening multiple templets in two monitors

[Morgan]

I am using WindowsXP Professional. I am trying to figure out how to open
multiple templets/books inside of one excel application on two monitors. I am
not good with excel so I hope I am explaining this well. My example would be
when I open excel and I have multiple books at the bottom how can I drag one
book to my other monitor?

 

[Gord Dibben]

See Chip Pearson's site.

http://www.cpearson.com/excel/MultipleMonitors.aspx


Gord Dibben MS Excel MVP

 

[Morgan]

OK so you did answer the question I asked but I realized I was using the
wrong terminology. I need to be able to see multiple sheets within one book.
Is there away to separate the sheets from one book with in excel to two
monitors?

 

[Gord Dibben]

Start out with two windows of same workbook.

Window>New Window

Window>Arrange>Vertical.

Switch one window to another sheet in same book.

Now stretch Excel across both monitors as Chip describes.

I don't have two monitors but should work.

Basically the same as having two workbooks open.


Gord Dibben MS Excel MVP