How can I open multiple excel files and view them all at once? Currently I
can only view them one at a time in the same window.

It's under windowarrange, then select how you want to arrange all open
workbooks

Regards,

Peo Sjoblom

"Starblazer" wrote:

How can I open multiple excel files and view them all at once? Currently I
can only view them one at a time in the same window.

Open all your files then click Window in the menu and select Arrange...
choose from Tiled, Vertical or Horizontal layouts

hope this helps.

Nadia

"Starblazer" wrote:

How can I open multiple excel files and view them all at once? Currently I
can only view them one at a time in the same window.

Thanks, not quite what I was looking for but it does the job

"Peo Sjoblom" wrote:

It's under windowarrange, then select how you want to arrange all open
workbooks

Regards,

Peo Sjoblom

"Starblazer" wrote:

How can I open multiple excel files and view them all at once? Currently I
can only view them one at a time in the same window.

Perhaps you were thinking of ToolsOptionsView "Windows in Taskbar"?

Gord Dibben Excel MVP

On Tue, 21 Dec 2004 15:11:01 -0800, "Starblazer"
wrote:

Thanks, not quite what I was looking for but it does the job

"Peo Sjoblom" wrote:

It's under windowarrange, then select how you want to arrange all open
workbooks

Regards,

Peo Sjoblom

"Starblazer" wrote:

How can I open multiple excel files and view them all at once? Currently I
can only view them one at a time in the same window.

Open the first worksheet from the start menu, and then open the second again
from the start menu again, follow the same procedure for each worksheet after
that.

To work with the same worksheet in separate windows, open the first
worksheet, go to the €˜Tools menu and select the €œShare workbook€�, in the Edit
tab place a check in the box €œAllow changes by more than one user at the same
time.

This also allows workbook merging. Then open another Excel window from the
Start menu, and use the File Open for another instance of the same
worksheet.

Read and understand the share rules, and options in the advanced tab.

Be careful when saving the workbooks.


"Starblazer" wrote:

How can I open multiple excel files and view them all at once? Currently I
can only view them one at a time in the same window.

Open the first file as normal. Then open a new excel window as if you're
going to create a new workbook, on this blank workbook, use the "Open" option
from the "File" menu (or from the Microsoft ribbon in 2007 version) to open
the other file. Works with 2007 version.


"Starblazer" wrote:

How can I open multiple excel files and view them all at once? Currently I
can only view them one at a time in the same window.