how to view excel sheets side by side

View Excel Sheets Side by Side: Easy Steps for 2023

By Steven Young
AD

Are you finding it challenging to compare data from different Excel sheets? Learning how to view Excel sheets side by side can greatly improve your productivity and enable you to compare and contrast data more effectively. In this guide, we'll explore how to accomplish this using Excel's built-in features.

Before we dive into the steps, it's important to understand that viewing Excel sheets side by side is not natively supported. However, you can achieve this using window management techniques and a little bit of tweaking. Let's get started.

Using Windows Taskbar to View Excel Sheets Side by Side

The Windows taskbar is a powerful tool that can be used to view Excel sheets side by side. This method allows you to compare sheets quickly and easily.

AD
How To View Two Sheets Side-by-side In The Same Excel File
How To View Two Sheets Side-by-side In The Same Excel File
How to View Two Sheets Side by Side in Excel
How to View Two Sheets Side by Side in Excel
How to view sheets side by side in Excel
How to view sheets side by side in Excel

Here's how to do it:

Arranging Windows Side by Side

1. Open the two Excel files you want to compare.

How to Enable Vertical Side-by-Side View in Excel - 4 Methods - ExcelDemy
How to Enable Vertical Side-by-Side View in Excel - 4 Methods - ExcelDemy
Compare Sheets Side By Side
Compare Sheets Side By Side

2. Click on the taskbar icon of the first Excel window to select it.

3. While holding down the Shift key, click on the taskbar icon of the second Excel window.

AD

4. Right-click on either selected taskbar icon and choose "Show windows side by side".

Adjusting Windows Size

1. After arranging the windows side by side, you may need to adjust their size to fit the content of both sheets.

2. Hover your mouse cursor over the border between the two windows to resize them.

AD

3. You can also drag the borders to adjust each window's size individually.

Using Screen Resolution and Window manager

Another way to view Excel sheets side by side is by manipulating your screen resolution and using a window manager. This method is more suited for users who prefer a more natural comparison experience.

Here's how to do it:

AD

Adjusting Screen Resolution

1. Right-click on your desktop and select "Screen resolution".

2. Change the resolution to a value that allows both Excel windows to fit side by side comfortably, for example, 1920x1200 for dual monitors.

3. Click "Apply" and then "OK".

Manipulating Windows using a Window Manager

1. Download and install a window manager like AutoHotkey or a built-in Windows feature like "Snap Assist".

2. Use the window manager to snap the two Excel windows to the left and right sides of your screen, respectively.

3. (For AutoHotkey users)You can create a script that automatically snaps windows side by side for quicker access.

In many cases, you might find yourself frequently needing to compare data from different Excel sheets. Fortunately, knowing how to view Excel sheets side by side can make this process a breeze, saving you time and effort in the long run.

AD