How to solve the problem of being unable to enter Chinese characters in an Excel spreadsheet and only typing letters?

Excel spreadsheet is a data processing software that can collect and enter various data information. However, some friends today reported that only English letters and numbers can be entered in the Excel spreadsheet, but Chinese characters cannot be input. How to solve the problem? Next, the editor will share the specific solution steps with my friends, let’s take a look together. Operation steps 1. Click to open the Excel table that needs to be processed.

2. Click Data Verification - Data Verification in the Data tab.

3. After entering the window, switch to the input method mode bar, click the drop-down arrow at the mode to select any, and then click OK.

4. Enter again and you can enter Chinese normally.

5. In addition, we can check whether the input method is in Chinese mode. Press the shift key or Ctrl + space bar to adjust it to Chinese mode, and then you can successfully input Chinese.

The above is the detailed content of How to solve the problem of being unable to enter Chinese characters in an Excel spreadsheet and only typing letters?. For more information, please follow other related articles on the PHP Chinese website!