Mulitple Spreadsheet View Problems

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daren - 19 Jul 2007 22:08 GMT

I'm trying to have two open spreadsheets side by side on the bottom of my
desktop computer. When I open the second file, it is placed over the first
file, and I have to minimize the second file to get back to the first file.
How can I set up excel to have these two worksheets side by side on desktop?
Thanks.

Reply to this Message

garfield-n-odie [MVP] - 19 Jul 2007 22:29 GMT

In Excel 2002 or 2003, open the two spreadsheets, and click on Window |
Arrange | Vertical.

> I'm trying to have two open spreadsheets side by side on the bottom of my
> desktop computer. When I open the second file, it is placed over the first
> file, and I have to minimize the second file to get back to the first file.
> How can I set up excel to have these two worksheets side by side on desktop?
> Thanks.

Reply to this Message

Daren - 19 Jul 2007 22:46 GMT

That worked. Thanks. I'd also like to have the two workbooks side by side
on the bottom toolbar. How can I do that?

> In Excel 2002 or 2003, open the two spreadsheets, and click on Window |
> Arrange | Vertical.
[quoted text clipped - 4 lines]
> > How can I set up excel to have these two worksheets side by side on desktop?
> > Thanks.

Reply to this Message

garfield-n-odie [MVP] - 19 Jul 2007 22:50 GMT

Tools | Options | View tab | check the "Windows in Taskbar" box | OK.

> That worked. Thanks. I'd also like to have the two workbooks side by side
> on the bottom toolbar. How can I do that?
[quoted text clipped - 7 lines]
>>>How can I set up excel to have these two worksheets side by side on desktop?
>>>Thanks.

Reply to this Message