How do I open Excel in two windows in Windows 7?
5 Answers
- Open your first Excel file and place it on the screen you want.
- Open a new Excel file from the Excel icon (New instance of excel needed)
- The new file will open on top of the one you have already opened. Drag it to the other screen.
- Drag the icon for the second Excel file INTO the new (blank) Excel document.
How do I view Excel spreadsheets on 2 different monitors?
Open the first file in Excel and drag the window to the monitor where you want to view that file. Press the Shift Key and click the Excel Taskbar icon to open a second instance of Excel. Position that new window onto the other monitor. Use File/Open to open the second file in that window.
How can I open 2 Excel files in different windows?
- Open your first Excel file and place it on the screen you want.
- Open a new Excel file from the Excel icon.
- The new file will open on top of the one you have already opened. Drag it to the other screen.
- Drag the icon for the second Excel file INTO the new (blank) Excel document.
How do I have two Excel windows open?
Press the Shift Key Alternatively, you can open multiple Excel windows by pressing and holding the Shift key. First, open the Excel software. Then hold the Shift key, and click Excel’s taskbar icon. That will open another window for the application that users can drag to both desktop sides as outlined above.
How do I open two Excel files in different windows?
Open Excel workbooks in new windows with holding Shift key and clicking in Taskbar. For the usage of lowest versions of Excel, with holding the Shift key and clicking the Excel icon in the Taskbar, you can open Excel workbooks in multiple windows.
Why I Cannot open two Excel files side by side?
Make sure you are in window mode and not have your window maximized. 2. Extend the Excel window to cover both screens by dragging the window edges.
How do I open two Excel files side by side vertically?
You can work in either or both windows and the workbook will be updated. You can also arrange those windows to appear side-by-side. In the ribbon, click View > Arrange All > Vertical > OK. The two workbooks will now appear in the same window, as shown below.
Can’t open 2 Excel files at the same time?
By default, Excel will use an already running instance to open other files. Simply open up Excel, then open your file. Then open up a second copy of Excel and open the second file. Now you can move the two Excel instances independently to your other monitor.
How do I open multiple Excel files at once?
To do this, follow these steps: Choose Open from the File menu. Excel displays the Open dialog box. Instead of double-clicking on a file name, start to create a “selection set.” If you are selecting sequential files, click on the first file in the sequence, then hold the Shift key as you click on the last.
How do I open 2 Excel files?
How to open two Excel files in multiple monitors in Windows 7?
This will give you 2 excel windows. In the 2nd excel window, open up your second excel document by going to file / open / and then browse for your 2nd excel file. Now you will have 2 excel documents, each in their own window. Just follow these steps and there is no need to replace the icon (at least in Windows 7):
Is there a way to spread an Excel file across two screens?
You can also spread the Main excel file across both screens and then use View > Arrange Windows > Tile Vertically. You need to open 2 instances of Excel, move each one to a monitor and then open the files.
How can I open two Excel files at the same time?
Open Excel again from the shortcut and leave it on the first monitor. Drag the first Excel file that you want to open into the first Excel window and drag the second Excel file that you want to open into the second Excel window. Now you have two Excel files open in two Excel windows and on two monitors.
How to open Excel spreadsheets in separate windows?
How to Open Excel Spreadsheets in Separate Windows for Windows 7 or Earlier We will go to the Start menu, click on All Programs, tap Microsoft Office and select Excel. Alternatively, we can type Excel in the Search button to bring up the program icon. Next, we double-click on it to open.