Pinterest Pixel

How to View Multiple Worksheets in Excel

I usually have a workbook that has a lot of worksheets, and I have to view multiple... read more

Download Excel Workbook
Bryan
Posted on

Overview

How to View Multiple Worksheets in Excel | MyExcelOnline How to View Multiple Worksheets in Excel | MyExcelOnline

I usually have a workbook that has a lot of worksheets, and I have to view multiple sheets at the same time. Switching tabs back and forth just to compare the contents drives me nuts!!

Did you know that you can view multiple worksheets in Excel? Let me show you how!

I explain how you can do this and please go to the bottom of the page to see the animated gif tutorial:

How to View Multiple Worksheets in Excel | MyExcelOnline

Download excel workbookHow-to-View-Multiple-Worksheets-in-Excel.xlsx

STEP 1: Go to View > Window > New Window

How to View Multiple Worksheets in Excel

You will notice that there is a new window that is opened. You can notice that there is a number at the end of the filename indicated the window number.

How to View Multiple Worksheets in Excel

 

STEP 2: Now let’s arrange the windows to view all of them side by side!

Go to View > Window > Arrange All

Select Vertical and Click OK.

How to View Multiple Worksheets in Excel

Now you can view multiple worksheets from the same Excel file!

See also  Add Calculator in Excel to the Toolbar

How to View Multiple Worksheets in Excel

 

How to View Multiple Worksheets in Excel

 

Helpful Resource:

728x90

 

If you like this Excel tip, please share it
How to View Multiple Worksheets in Excel | MyExcelOnline How to View Multiple Worksheets in Excel | MyExcelOnline
How to View Multiple Worksheets in Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...