Solution: First open the excel table that needs to be operated, click the "File" tab at the top of the page; then select "Options" and click the "Advanced" tab in the pop-up "excel options" setting interface; Then check "Press Enter to move the selected content" and select the specified direction in the "Direction" drop-down list.
The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.
If you want Excel to press enter and line break, you can use the following method to set it.
First open the Excel software (take office 2010 as an example) and click the "File" tab in the upper menu bar.
#Click "Options" in the menu bar on the left side of the pop-up file information interface.
#In the pop-up Excel option setting interface, click the "Advanced" tab on the left.
Under the editing options of the advanced option setting interface, the drop-down box after "Direction" can select the direction in which the cell will jump after pressing Enter, among which "Down" Just press Enter to change the line.
After selecting the direction "Down", also check the "Move the selected content after pressing the Enter key" item, and click OK to complete the settings. In this way, you can press Enter in the Excel table to wrap the line.
Related learning recommendations: excel tutorial
The above is the detailed content of What should I do if the Enter key cannot wrap in the Excel table?. For more information, please follow other related articles on the PHP Chinese website!