Let's talk about Excel multi-window operation

This article brings you excel related knowledge, which mainly introduces the relevant content about multi-window operations and how to perform multi-window operations. Let’s take a look at it together. I hope it will be helpful to everyone. helpful.

Related learning recommendations: excel tutorial

Today we talk about multi-window operations in Excel.

As shown in the figure below, there are two months of sales data, which are placed in different worksheets.

What should I do if I want to view two months of sales data at the same time?

Step one:

Click the [New Window] command under the [View] tab.

At this time, Excel will have an identical Excel interface, and a serial number will be automatically added after the file name:

Second step:

Click the [View] → [Rearrange All] command in sequence, and select an arrangement method in the dialog box, such as vertical side by side:

This will display the left and right Excel windows:

Step 3:

Click [View Side by Side] under the [View] tab.

Step 4:

Switch to another worksheet in one of the Excel windows, roll the mouse wheel, and see the effect:

If two workbooks are opened at the same time, just click [View Side by Side], and the two workbooks will be displayed left and right immediately, and they can also be viewed side by side. Give it a try.

We can also view the data in the same worksheet in sections. First click the cell you want to segment, and click [Split] under the [View] tab:

Excel will automatically divide the Add spacer lines on the left to split the window. Each window can be scrolled and viewed independently. Isn’t it particularly fun?

#Click the [Split] button again and the window will return to its normal state.

Related learning recommendations: excel tutorial

The above is the detailed content of Let's talk about Excel multi-window operation. For more information, please follow other related articles on the PHP Chinese website!