This guide will teach you how to open multiple worksheets in one Excel file at the same time. It will help you to view the contents of two or more worksheets side by side.
Because basically, you can’t open a workbook more than once at the same time. This is what makes it difficult for some users to see all their worksheets.
Important! If you want to open multiple Excel files at once, please follow the View Multiple Workbook in Excel guide.
Now, let’s see how to view two or more worksheets in the same workbook at the same time.
Table of Contents:
Steps to View Multiple Worksheets in Excel at Once
For example, I have an Excel file containing 3 worksheets. Each sheet contains product sales data for each branch of the company, namely Washington, New York, and Las Vegas.
This is what my workbook looks like:
Now, to view these three worksheets at once, you can’t open an Excel file more than once at a time. So, you have to open a new window from within that Excel file in the following way:
- Open your first sheet. In this example, it’s a Washington sheet.
- In the View tab, click New Window in the “Window group”. Automatically, Excel will open a new window for the same workbook.
- Currently, there are already two views for one Excel File. To open the third view, repeat steps 1 and 2 above. If you have, then one of your excel files will open as many as 3 windows as shown below:
As shown above, it can be seen that only one Excel file is opened. It’s indicated by the Excel File Name ending in the number. The meaning of this number is the display number.
For example, a window with the name “Multiple Worksheets.xlsx1” is the first display. While the window “Multiple WorkSheets.xlxs2” is the second display. Likewise with the third window. - Next, to see all the worksheets side by side, please click Tab View > Arrange All in one of the windows.
arrange all, the select vertically to open multiple Worksheets in one file Excel at once”>
In Arrange Windows, select a display type. For example, select Vertical then click OK and this is the result:
Note: Any changes to one window will be applied to the other window.
You can close any window without fear of losing your changes. However, while one window remains open, Excel will ask you to confirm whether to save changes or not.
Guide Shortcuts: Excel Worksheets
Previous Chapter: Workbook
- Worksheets: Understanding, Adding, Renaming, Deleting, Moving and Copying Worksheets.
- View Multiple Worksheets: You’re here!
Next Chapter: Ribbon