Need to See Two Excel Worksheets Simultaneously?


Sometimes you may  need to see two worksheets in the same workbook side by side. I have actually had folks write to me asking how they can do this.  I tell them, relax – it isn’t all that difficult.

Follow the steps below to learn how:

  1. Open the your first worksheet.
  2. On the View tab of your Ribbon, click New Window.
  3. If your workbook is in full screen mode, you might not notice that anything has happened, but if you take a peek at your title bar, you will see that your workbook title now has a :2 after it.
  4. On the View tab, click Arrange All and click either Vertical or Horizontal.
  5. In the second window, click the second worksheet tab that you would like to view. You can now see both your worksheets of the same workbook side by side.

To return to a single window, click the Close window icon, which is the white X int he top right corner of your Excel screen.

About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol’s Corner Office or follow Carol on FaceBook and Twitter.