Menu
- Open Excel In Separate Windows In 2010
- Open Excel In Separate Windows 2010
- How To Open Two Excel Spreadsheets Separ…
- Excel How To View Separate Windows
How to open/view multiple Excel files in different windows. First, you need to open multiple instances of Excel 2010, and then separately open the Excel files in different instances of Excel, so that you can view the workbooks in different monitors at the same time. Step 1: Open multiple instances of Excel 2010.
- 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. Firstly you need to open a workbook in advance, and then hold the Shift key on the keyboard.
- 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. Firstly you need to open a workbook in advance, and then hold the Shift key on the keyboard.
- Dec 08, 2017 Once we covered how to view Excel workbooks side by side. But there is another, presumably non-standard, task that appears to be very popular - to open your Excel 2016 or 2013 spreadsheets in different windows.
This week we continue exploring new features in Excel 2013.This post is brought to you by Chad Rothschiller, a Program Manager in the Excel Team.
Open Excel In Separate Windows In 2010
“How do I open my workbooks in separate windows?” This has been a common inquiry from many of our customers who want to look at their workbooks side by side, or spread them across more than one monitor.
Good news: starting with Excel 2013, each of your workbooks opens in its own window, similar to Word and PowerPoint today. That means that each workbook has its own ribbon and top-level window frame that you can move and resize independent from your other open workbooks. This functionality can improve multitasking, visibility, and analysis across workbooks.
In computing terminology, this is called Single Document Interface(SDI). Versions of Excel before the 2013 release used Multiple Document Interface (MDI), where all workbook windows were contained within a top-level “master” container window.
Open Excel In Separate Windows 2010
Here’s an example of four new workbooks. Note that each one has its own window and ribbon:
Microsoft Excel
Turn data into insights.
Get ExcelHow to arrange your windows
Now that you have multiple windows, how should you arrange them? Well, there are plenty of options and below are some favorites:
Smart Snapping: Grab the top of the window, and drag it to the top, left, or right edge of your screen, then let go. The window automatically resize:
- Drag Left: Position on the left half of the screen
- Drag Right: Position on the right half of the screen
- Drag Top: Fills the entire screen
Windows Taskbar: If you hold down the Shift Key and then right click the Excel icon on the Windows Task Bar you will see options for arranging your open windows. The cool thing about these options is that if you have multiple monitors, Windows remembers each workbook’s monitor and arranges workbooks displayed within the same monitor.
Excel Ribbon: Click on View the Arrange All to see more options for arranging your workbooks:
How To Open Two Excel Spreadsheets Separ…
Note that you can still create new windows (or multiple windows) showing the same workbook. Similarly, the “View Side by Side” and “Synchronous Scrolling” features work just like they used to.
Excel How To View Separate Windows
Tell us what you think
Thanks for learning more about this new feature in Excel 2013. I hope you all get wonderful benefits from being able to arrange workbooks on your screens! In a future post, we’ll go into a couple more advanced topics such as “Merging Instances and Long Running Operations” and how they work with pre-existing add-ins. In the meantime, let us know in the comments how you’re planning to use this new feature or anything else you’d like to see in future versions.
--Chad Rothschiller, Excel Program Manager