Excel teaches you to define different input methods for different types of cells

Source: Internet
Author: User

In a worksheet, there are usually numbers, letters, and Chinese characters. So, when we edit different types of cells, we need to constantly switch between Chinese and English input method, which not only reduces the efficiency of editing, but also makes people feel trouble. The following method enables Excel to automatically switch input methods for different types of cells:

1. Select the range of cells you want to enter Chinese characters, click data → effectivity, select the Input Mode tab in the Data Validation dialog box, select Open in the Mode Drop-down list, click OK ();

2. Similarly, select the range of cells that you want to enter letters or numbers, click data → effectivity, select the Input Mode tab, select Close in the Mode Drop-down list, and click OK. After that, when the insertion point is in a different cell, Excel automatically switches between Chinese and English input methods according to the above settings, thus improving the input efficiency.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

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: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.