S
Starblazer
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.
can only view them one at a time in the same window.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
It's under window>arrange, then select how you want to arrange all open
workbooks
Regards,
Peo Sjoblom
workbooks
Regards,
Peo Sjoblom
N
Nadia
Open all your files then click Window in the menu and select Arrange...
choose from Tiled, Vertical or Horizontal layouts
hope this helps.
Nadia
choose from Tiled, Vertical or Horizontal layouts
hope this helps.
Nadia
S
Starblazer
Thanks, not quite what I was looking for but it does the job
G
Gord Dibben
Perhaps you were thinking of Tools>Options>View "Windows in Taskbar"?
Gord Dibben Excel MVP
Gord Dibben Excel MVP
E
Elah4
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.
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.
G
Gina
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.
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.