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:

DOWNLOAD EXCEL WORKBOOK

STEP 1: Go to View > Window > New Window

How to View Multiple Worksheets in Excels

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!

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 itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

How to Group Worksheets in Excel Ever had a time when you needed to modify data across multiple worksheets?  It is very easy to do this using the Group Worksheets feature in Excel!Let us say we have this same mistake on multiple worksheets -  see the Dvv typo in the screenshot below.  We want to change this ...
Add the Calculator to the Excel Toolbar There were times when I had to find my Calculator App while I was doing some quick calculations in Excel.Instead of scrambling for the Calculator Application, you can actually have this inside of Excel!Excel has a lot of customizations and one handy tool is to include the...
Smart Lookup in Excel 2016  There were times when I was working in a spreadsheet and I had to do a quick internet search to understand some of the words in my cells.The process was, copy the text, paste on my browser, and click search.Little did I know that in Excel 2016, there is a featur...
How to Unhide Columns in Excel We normally use "helper columns" to do calculations in our Excel worksheet.  These "helper columns" are for our own internal use and we usually hide these columns so no one else can see them, like our evil boss!But once we are done with presenting our Excel worksheet to our e...