View Multiple Worksheets in MS Excel

View Multiple Worksheets

Just like viewing multiple workbooks at a time, you can view multiple worksheets within a single workbook, side by side.

To have a better understanding of this concept, follow the steps below:

1. Create atleast 2 worksheet in your MS Excel Workbook and fill them with some data.

sheet 1

2. Select View tab and under the Window tab, select New Window

new window

3. This action will split your Workbook into windows for multiple sheets.

multiple sheets

4. Now again, select View tab and select Arrange All under the Window section

arrange all

5. This will open an Arrange Window popup. Select Vertical, also check Windows of active workbook and click OK.

vertical

6. This will tile all your worksheets within the single workbook into Vertical format.

single workbook into Vertical format

Search

Shortcodes Ultimate

 
Follow Us
 
BGP