How to quickly select a worksheet

Source: Internet
Author: User
Tags table name

If you have a fairly large number of worksheets in your workbook, how do you quickly select a worksheet after you open the workbook?

For example, in the following workbook, there are 11 worksheets, and the table names use numbers.

In other words, if you have dozens of or even more than 100 worksheets, how can you quickly select the form you want to open from among the many table names?

The method is as follows, there are two methods.

I. General Benefit method

Look at the picture below, the part of the red circle, called the Name box.

Computer Tutorials

Enter the name of the table in the Name box, and then type the exclamation point into the A1 cell, and then press ENTER to quickly select it. The input in the Name box, formatted as:

Table name! Cell Address

For example, sheet99! A1

This method, which is a fast and versatile method, is applicable in any case. The key point is that you must remember the name of the table.

Ii. the method of expedient choice

If you don't have a lot of tables, you can use this method.

Pay attention to the part of the red line of the map, as long as the right mouse click that part, will pop up the list of the names of all tables, and then you can use the mouse to find and select the name of the table you want to select.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

11.11 Big Sale for Cloud

Get Unbeatable Offers with up to 90% Off,Oct.24-Nov.13 (UTC+8)

Get It Now >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.