« Ergo-what now? (recap) | Main | Is your library a PokéStop in Pokémon GO? »

How to view multiple worksheets from the same workbook

I recently attended a class entitled "Advanced Microsoft Excel Techniques".  In this class I learned a lot of things that Excel can do that I never knew it could.  One of these things is the ability to view multiple worksheets, side-by-side, from the same workbook in the same Excel window.  Here's how you do it:

  1. Open the desired workbook
  2. Click the View tab
  3. Click New Window
  4. Click Arrange All on the View tab
  5. Click Vertical or Horizontal
  6. Check the checkbox in front of "Windows of active workbook
  7. Click OK

Voila!  You now have two worksheets open side-by-side.

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

Post a comment