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

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.