skill

1212Currently online
167Today's Reading
46Share Today
Multilingual display

How does excel put multiple worksheets on one interface at the same time?

2018-05-15 04:48:02

This article explains how excel can view multiple worksheets in one interface at the same time.

Tools/Materials
1

wps 2020

2

computer

Methods/Steps
1

This content has been taken from experience without authorization

2

Click the "" window under" "View" on the menu bar.

3

Then go to the "Rearrange" window under the view toolbar and choose horizontal tile or vertical tile according to the format of the table. Here the table is vertical, I choose vertical tile.

4

At this time, we will find that the interface has shown two tables side by side, we can select the worksheet displayed on each page in the bottom left of the table.

5

To open the third table, we just need to click on the window again, and the new worksheet will appear on the screen in the previous orientation. And so on, we can choose the number of Windows according to our needs.

Recommendation