View Spreadsheets Side-by-Side

View side by side

Previous versions of Excel have had an option for viewing two spreadsheets side-by-side. However, Excel 2013 now makes it easier by allowing you to snap each spreadsheet (opened in separate windows) to each side of the screen. There are four types of side by side view:
1. Tiled view
2. Horizontal view
3. Vertical view
4. Cascade view

 

Enabling vertical view

Simply drag one of the windows to the side of the screen until you see a circle briefly spread out from the cursor. The Excel window will snap to that side of the screen, taking up half the screen. Once you snap both windows to either side of the screen, your two spreadsheets will be displayed as shown in the image below.

view side by side 1

You can also use the View Side by Side option, which is still available on the View tab in the Window section.

view side by side 2

By default, the View Side by Side option displays the two spreadsheet windows horizontally. To change the view, click Arrange All in the Window section of the View tab.

view side by side 3

The Arrange Windows dialog box displays. Select Vertical to view the windows side by side, as you did when you snapped them to the sides of the screen.

view side by side 4

Tiled does the same thing as Vertical when there are two spreadsheet windows open. If you have more than two spreadsheets open, Tiled will arrange them as tiles on the screen some horizontally, some vertically, depending on how many are open.

 

Enabling Tiled view

With the above mentioned process we can enable tiled view for our opened spreadsheets.

view side by side tiled

 

Enabling cascade view

Cascade displays the spreadsheet windows with the title bars cascaded down the screen. With the above mentioned process we can enable tiled view for our opened spreadsheets.

view side by side cascade

 

 

Enabling horizontal view

With the above mentioned process we can enable tiled view for our opened spreadsheets.

view side by side horizontal

 

Activate synchronous scrolling

If you want to scroll through both (or all) spreadsheets at the same time, you can turn on the Synchronous Scrolling option in the Window section of the View tab. This will allow you to scroll through both windows using the scroll bar on one of them.

view side by side scrolling

 

SDI and MDI means

Each spreadsheet opening in its own window, like in Word and PowerPoint, is called Single Document Interface (SDI). That means that each spreadsheet has its own Ribbon and title bar so you can move the window around and resize it independently from your other open spreadsheets. Previous releases of Excel used the Multiple Document Interface (MDI), in which all spreadsheet windows opened under a top-level, “master” container window.

The SDI now used in Excel 2013 makes it easier to compare multiple spreadsheets side by side.

2 thoughts on “View Spreadsheets Side-by-Side

  1. Golam Mustafa

    It’s really help me a lot which exactly i’m looking for. Thanks for the article bro…

  2. As soon as I discovered this website I went on reddit to share some of the love with them.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment