How Excel cells automatically switch input methods

when you make Excel worksheets, you often have both data and text, and the adjacent cells may be alternating between Chinese characters and numbers and symbols. In this way, in the input will need to repeatedly switch between Chinese and English input method, very troublesome. This technique allows the cell to automatically switch input method, where the cursor is intelligent to open the corresponding input method, eliminating the trouble of manual switching.

Open the Excel table, and then open the Chinese input method you used. Select the range of cells that you want to enter Chinese. Click the Input Mode tab in the Data Validation window under Data Tools grouping, select Open in the Mode box, and click OK.

Select the range of cells that you want to enter a number or half-width character in, select Close (English mode) in the input mode box of the Data Validation dialog box, and click the OK button.

All areas are set as above.

After such a simple setting, with the mouse in the area just set up after the selection of cells (or by carriage return, tab, etc.), Chinese and English input methods can automatically switch. Simply enter the appropriate type of content just as needed.