On UrbanPro

View My Profile       Proud to be a Teacher       Write a Review  

Friday, January 20, 2017

Arrange and View Multiple Worksheets at Once in Excel

This feature allows you to view multiple worksheets at once from the same workbook at the same time.

 You need to follow beneath simple steps to view multiple worksheets at once from the same workbook at the same time:

  1. Go to the View tab and click New Window



















  2.  Then click Arrange All




















  3. Select either Horizontal or Vertical and put a check next to Windows of active workbook and then click OK.















  4. Result:You will now have two separate views of the same workbook.


















You can view different worksheets in each pane or the same worksheets, it doesn't matter.

Each side is independently controlled. This allows you to avoid flipping between the tabs to compare information.

When you are finished with this view, just close one of the windows and maximize the other one so it fills the Excel window.