Shulou(Shulou.com)11/24 Report--

Hello everyone! I am Green Water Zero!

My main job in the unit is to collect data, and it's January again, and it's time to collect annual plans again.

Recently processed documents have multiple worksheets, which need to be switched back and forth for entry, review and check.

To remove your hand from the keyboard, click the label of a worksheet with the mouse, and move your hand back to the keyboard. Do you find it quite annoying?

And when it is found that the data of a worksheet is incorrect, it takes half a day to find the desired table from dozens of tables.

How could I let myself use such a stupid way when I came out of Akiba Excel training camp?

So, is there any way to quickly switch back and forth between multiple worksheets and install Xs?

Of course there is! Otherwise, I wouldn't have written this article.

Loading level: Level 1 has three worksheets of [member information] [order details] [logistics details] in a workbook.

You need to enter information back and forth between the three worksheets, "how to switch quickly?" "

This workbook has three worksheets, and generally the input information is entered in a certain order, so it is best to switch the worksheet in order.

👉 impersonates the secret book:

Use the shortcut key [Ctrl+PageDown] to quickly switch to the next worksheet.

Use the shortcut key [Ctrl+PageUp] to quickly switch to the previous worksheet.

Pretending to force the level: Level 2 or the above table, when switching, the leader in the side, in the middle of some messy forms do not want to let the leader see, is there any way?

Take the above table as an example, for example, if you want to skip [order details] and switch directly from [member Information] worksheet to [Logistics details] worksheet.

👉 impersonates the secret book:

❶ selects any cell

❷ press [F6] key

❸ uses the left and right arrow keys to switch between worksheets so that the green box falls on the worksheet to be selected

❹ press the [Enter] key.

Loading level: Level 3 switches from a workbook that contains dozens of worksheets to a specific worksheet, as shown in the following figure:

There are 30 branches in this document, and each branch has a separate worksheet. If you want to switch to branch 15, of course you can't turn it page by page!

👉 impersonates the secret book:

❶ right-click in the navigation area in the lower left corner of Excel

❷ selects the worksheet to open in the activation window [branch 15]

❸, click [OK].

Got it!

There are many ways to switch worksheets. Only by choosing according to the actual scene can we effectively improve the work efficiency.

Summarize the three tips in this article:

👉 [PageUP] and [PageDown]:

It is suitable for switching page by page sequentially.

👉 [F6] key:

Similar to the methods of [PageUP] and [PageDown], it is also switched sequentially, but the middle worksheet can not be displayed.

Right click in the 👉 navigation area:

It is suitable for fast switching when there are too many forms.

Hurry up and learn so that you can come and go and switch reports like the wind.

If you want to be as good as Green Water Zero,

You also want to encounter problems, ask questions on the spot, answer questions on the spot, and never have to scratch your head alone.

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: green Water Zero

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.