Opening Excel sheets side by side can significantly improve your productivity and data analysis capabilities. Whether you're comparing data, consolidating information, or simply need to work on multiple spreadsheets at once, having them visible simultaneously allows for quick cross-referencing and efficient multitasking. Here are three easy ways to achieve this:
Method 1: Using the Arrange Windows Feature
The Arrange Windows feature in Excel is a straightforward tool for side-by-side viewing:
- Open all the Excel workbooks you need to view simultaneously.
- Click on the View tab in the Ribbon.
- Click Arrange All from the Window group.
- From the options, select Vertical, Horizontal, Cascade, or Tiled depending on how you want the windows to be displayed.
Arrangement Description Vertical Windows will be placed side by side vertically. Horizontal Windows will be placed one above the other horizontally. Cascade Windows are slightly overlapped with each window showing its title bar. Tiled Windows are evenly spread on the screen. 
🏆 Note: Keep your Excel version updated for the best experience with the Arrange Windows feature.
Method 2: Using the View Side by Side Feature
This feature is particularly useful for comparing data across two Excel sheets:
- Open the two workbooks you wish to compare.
- In one workbook, go to the View tab, and click View Side by Side.
- If you have more than two workbooks open, Excel will ask which second workbook to view.
- Use Synchronous Scrolling if you want to scroll both workbooks simultaneously.
This method aligns the worksheets such that any movement in one sheet is mirrored in the other, making it easy to compare content at the same position.
Method 3: Using a Second Monitor or Screen Splitting
If you have the hardware, using a second monitor or splitting your screen can provide the most flexible side-by-side viewing:
- Dual Monitor Setup:
- Open one workbook on your primary monitor and another on the secondary.
- Use Windows + Right Arrow or Windows + Left Arrow to move and maximize windows on separate screens.
- Screen Splitting:
- Open both workbooks on one monitor.
- Click and drag the window borders to manually split the screen into two parts, adjusting each window’s size as needed.
While a second monitor offers the most screen real estate, even a single monitor can be split effectively for multitasking.
đź’ˇ Note: If using dual monitors, be mindful of screen resolutions to prevent scaling issues.
By employing these methods, you'll find that comparing and working with multiple Excel sheets becomes more intuitive. Remember, the key is to choose the method that aligns with your work style and hardware setup. For instance, if you frequently deal with large datasets, using a second monitor or splitting your screen might be ideal. For quick comparisons, the View Side by Side feature might be more suitable. And for general multitasking, Arrange All could be the go-to. Each method has its benefits, making Excel a versatile tool for productivity in data handling and analysis.
Can I open more than two Excel files side by side?
+
Yes, you can open multiple Excel files at the same time using the Arrange All feature. This allows you to choose from different arrangements like tiled, horizontal, vertical, or cascaded to manage multiple workbooks simultaneously.
Does Excel remember my window arrangement?
+
Excel does not save the specific window arrangement from one session to another. However, you can quickly rearrange windows using the View tab when you reopen your files.
What if my system only has one monitor?
+
If you have only one monitor, you can still use the Arrange Windows feature or split the screen manually to view multiple Excel files side by side. Screen splitting can be as effective as a dual monitor setup if managed well.
