View multiple sheets in Excel

If you want to view multiple sheets of the same Excel document at once, follow the instructions below:

1. Open a document.
2. On the Advanced tab Vew (View) select New Window (New window). Excel will open a new window of the same document.
3. On the Advanced tab View (View) click Arrange All (Order all).
4. Select the desired display option. For example, Vertical (Top down).
5. Press ОК.

Titles view-multiple-worksheets:2 и view-multiple-worksheets:1 means that two windows of the same file are open.

6. open sheet Wk2 in the right window. Now you can view sales for the first and second weeks at the same time.

Note: Any changes made in one window will be immediately reflected in the other. To scroll both sheets at the same time, press the button View Side by Side (next to) in a group of teams Window (Window) tab View (View). In this case, synchronous scrolling will be enabled by default.