Work Faster by viewing Multiple sheets at once in Excel

[sumant-malhotra]

Stuck switching between screens again and again to match data in Excel??

Avoid the hassle, and simply use a multiple worksheet view, as shown below:

1. Open a workbook.

2. On the View tab, in the Window group, click New Window.

Excel opens a new window containing another view of the document.

3. On the View tab, in the Window group, click Arrange All.

4. Select the desired arrange setting. For example, click Horizontal.

5. Click OK.

The titles (view-multiple-worksheets:1 and view-multiple-worksheets:2) indicate that two windows of the same file are open.

6. In the lower window, select the sheet tab of Wk2. You can now view the sales in week 1 and week 2 at the same time.

Note: any changes you make to one window are immediately reflected in the other window.

7. On the View tab, in the Window group, click View Side by Side (by default, Synchronous Scrolling is activated), to scroll both worksheets at the same time.

This will improve your speed like CRAZY!!

NOTE: MS Excel is a commonly used Microsoft Office application. It is a spreadsheet program that is used to save and analyze numerical data. To see more help articles like the above, please visit my BI profile here: boardinfinity.com/u/coach/sumant-malhotra

Do leave a LIKE if this helped you, and don’t forget to drop in a comment if there are any suggestions!!