How to View Multiple Worksheets in Excel

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:

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

STEP 1: Go to View > Window > New Window

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.

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.

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

How to View Multiple Worksheets in Excel

Helpful Resource:

Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.