View Separate Worksheets at Once in Excel

Add to Favorites

This feature allows you to view multiple worksheets from the same workbook at the same time.

Steps

Go to the View tab and click New Window

e3be50150ad08e0cb95d2af7d9b82fc9.jpg

Then click Arrange All

b0cbbe18bedba5eb8a1c47b005065a44.jpg

Select either Horizontal or Vertical  and put a check next to Windows of active workbook and then click OK.

ba9165b42d3366ec26db815b20a55f20.png

You will now have two separate views of the same workbook.

94e62da40fc62da13b4118fe0755a94f.jpg

You can view different worksheets in each pane or the same worksheets, it doesn't matter.

Each side is independently controlled. This allows you to avoid flipping between the tabs to compare information.

When you are finished with this view, just close one of the windows and maximize the other one so it fills the Excel window.

Notes

This technique will save you a ton of time!

Download the file for this tutorial to try this out with the sample data above.


Downloadable Files: Excel File

Similar Content on TeachExcel
Print All Worksheets at Once in Excel
Tutorial: How to print all worksheets at once from Excel. This saves you the time of having to go to...
View Different Parts of a Worksheet at Once in Excel
Tutorial: View different sections of the same worksheet when the sections are far apart.  This allo...
Display all Formulas at Once in Excel
Tutorial: How to view all of the formulas at once in Excel so that you can troubleshoot the spreadsh...
Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter
Macro: This Excel macro allows you to filter a data set on multiple columns and criteria at once....
Quickly Resize Multiple Columns or Rows at Once in Excel
Tutorial: How to quickly resize multiple columns and rows at once in Excel.  This avoids having to ...
View Separate Parts of a Worksheet at Once in Excel
Tutorial: View separate parts of a large worksheet while in the same Excel window. This allows you t...
Tutorial Details
Downloadable Files: Excel File
Similar Content
Print All Worksheets at Once in Excel
Tutorial: How to print all worksheets at once from Excel. This saves you the time of having to go to...
View Different Parts of a Worksheet at Once in Excel
Tutorial: View different sections of the same worksheet when the sections are far apart.  This allo...
Display all Formulas at Once in Excel
Tutorial: How to view all of the formulas at once in Excel so that you can troubleshoot the spreadsh...
Excel Forum