Skip to main content
Skip to main content
Microsoft 365

Open Excel workbooks in separate windows and view them side by side

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.

View Excel workbooks side by side.“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.

Here’s an example of four new workbooks. Note that each one has its own window and ribbon:

Layered Excel worksheets.

Excel icon

Microsoft Excel

Turn data into insights.

Get Excel

How 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.

A view of the Windows Taskbar.

Excel Ribbon: Click on View the Arrange All to see more options for arranging your workbooks:

Using the Excel ribbon to arrange your windows.

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.

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

Related posts

Image for: View live transcripts in Microsoft Teams meetings, track Excel changes, and increase hybrid work security—here’s what’s new to Microsoft 365
• 5 min read

View live transcripts in Microsoft Teams meetings, track Excel changes, and increase hybrid work security—here’s what’s new to Microsoft 365

This month, we're announcing some top requested features like tracking changes in Excel and live transcriptions in Teams, as well as some soon-to-be-favorites like meeting recaps, turning Word documents in presentations, and more.

Image for: Family hanging out at home baking holiday cookies using Lenovo Ideapad Flex 3 to make holiday cards
• 5 min read

New apps and features in Microsoft 365 for individuals and families this fall

Since we introduced Microsoft 365 to individuals and families earlier this year, we have continued to deliver new innovations across our apps and services to help you and your family save time and stay connected. See what’s new below. Locate your loved ones and build better driving habits with Microsoft Family Safety Stay connected even…

Image for: A man is using his Lenovo laptop like a tablet while sitting in a comfortable chair in a Modern office setting
• 6 min read

Microsoft Productivity Score and personalized experiences—here’s what’s new to Microsoft 365 in October

As I reflect on an action-packed few weeks, I’m struck by how much work has evolved in these past months. And I know our customers feel it too. After quickly moving to remote and hybrid work models this spring, organizations are now seeking sustainable ways to help people collaborate, be productive, and prioritize their wellbeing…