Can I open two Excel files in one window?

Asked By camford 0 points N/A Posted on - 02/27/2012

Hey there, you guys!

I have a question about opening two Excel files in the same window. Usually, when I try to open two different files in Excel, they open in two separate windows.

What I want is that when I open a new file, or another copy of the same file, Excel would make the file viewable in the same window.

This way I will be able to stay within the same window and edit two separate files. I was wondering if there is an option in Excel that would help me do that. Any ideas or suggestions will be appreciated.

Thanks a lot!

• Status: Open
• Question Views: 1778
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Cabbie

Go To Solution

Best Answer

Best Answer

Answered By Cabbie 0 points N/A #93428

Can I open two Excel files in one window?

 

Hi Camford,

Yes, you can open two Microsoft Office Excel files in the same window side-by-side. You may also work on both files simultaneously, and save them into one Workspace for future use. 

This is the step-by-step guide on how to do so (with MS Excel 2007): (My apologies for not providing any screenshots as I have difficulty doing so)

1. Open the MS Excel files you wish to work on.

2. Click on VIEW > ARRANGE ALL 

(A pop-up window will appear on how you wish to arrange your window)

3. Click VERTICAL (The active window will be on the left-side)

And there you have it: Two MS Excel files in one window. Should you wish to save this so that you don't have to trouble yourself with the same process the next time you work on these files, continue with this steps:

4. Click on VIEW > SAVE WORKSPACE (You will be diverted into Save Workspace pop-up window)

5. Enter a filename you like. 

I hope you find this helpful. Best of luck! 

About Cabbie

Questions
1

Answers
1

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 02/28/2012
• Question Category: MS Excel

Answered By Morcelo Toldelo 10 points N/A #93427

Can I open two Excel files in one window?

Dear Comfort,

Opening two Excel files in the same window is very much important and useful. You can open two or more excel files at the same window and can compare two excel sheets.

Window office excel 2003 gives this great opportunity. If you want to open multiple excel file at a time and also want to edit two files at a time then please follow the procedure given Click Here

You will be able to stay within the same window and edit two separate files.

Thank you for your great query.

I hope you will do the task and will enjoy more editing excel files.

About Morcelo Toldelo

Questions
3

Answers
115

Best Answers
24

• Vote Up 0 Vote Down

• Posted on - 03/14/2012
• Question Category: MS Excel