How to open multiple spreadsheets side by side in Excel 2013

Previous versions of Microsoft Excel allowed viewing of two spreadsheets side by side. However, Excel 2013 makes it easier by allowing you to align two spreadsheets (open in two separate windows) to the left and right of the screen. The article explains how to put 2 or more Excel 2013 spreadsheets side by side or scroll through multiple spreadsheets at once.

The article explains how to put 2 or more Excel 2013 spreadsheets side by side or scroll through multiple spreadsheets at once.

Previous versions of Microsoft Excel allowed viewing of two spreadsheets side by side. However, Excel 2013 makes it easier by allowing you to align two spreadsheets (open in two separate windows) to the left and right of the screen.

Picture 1 of How to open multiple spreadsheets side by side in Excel 2013

To do this, simply drag a window to the side of the screen until a circle appears at the cursor. The Excel window will be on one side, occupying half the screen. After you place both windows on either side of the screen, two spreadsheets will be displayed but in the image above.

Picture 2 of How to open multiple spreadsheets side by side in Excel 2013

You can also use the 'View Side by Side' option in the 'View' tab of 'Window'.

Picture 3 of How to open multiple spreadsheets side by side in Excel 2013

By default, the 'View Side by Side' option shows two spreadsheet windows horizontally (one window is on top, one is under).

Picture 4 of How to open multiple spreadsheets side by side in Excel 2013

To change the view, click on 'Arrange All' in the 'Window' section of the 'View' tab .

Picture 5 of How to open multiple spreadsheets side by side in Excel 2013

The 'Arrange Windows' dialog box appears. There are options:

Picture 6 of How to open multiple spreadsheets side by side in Excel 2013

'Vertical': 2 windows will be placed side by side, just like when you align them to the left and right of the screen (as above).

'Horizontal': 2 spreadsheet windows are placed horizontally (one window is on top, one is under).

'Tiled': In case you open 2 spreadsheets, 'Tiled' will act like 'Vertical', placing 2 spreadsheets on the left and right sides of the screen.

In case you open more than 2 spreadsheets, 'Tiled' will arrange them into cells on the screen, depending on the number of windows opened. Same as the picture below:

Picture 7 of How to open multiple spreadsheets side by side in Excel 2013

'Cascade': Spreadsheet windows are arranged in hierarchical form.

Picture 8 of How to open multiple spreadsheets side by side in Excel 2013

If you want to scroll to view two (or all) spreadsheets at once, you can turn on the 'Synchronous Scrolling' option in the 'Window' section of the 'View' tab. At that point, you can scroll through both spreadsheets when moving the scroll bar on a window. This approach is useful when you want to compare two spreadsheets to find differences.

Picture 9 of How to open multiple spreadsheets side by side in Excel 2013

Update 25 May 2019
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile