We often need to wrap lines when creating tables in Excel. Some netizens asked if there is any quick way to wrap lines? Is there a shortcut key? In fact, there is. So what is the shortcut key for line wrapping in Excel? How to wrap rows in Excel table? The following article will introduce it to you, I hope it will be helpful to you.
Method 1. Use the line break shortcut key
The excel line break shortcut key is "Alt Enter (Enter)", which is used to Force a newline. You need to first use the cursor to determine the position where you want to wrap the line in the cell, then hold down "Alt" and press Enter, so that you will not jump to the next cell, but just wrap the line in this cell.
Method 2: Automatically adjust cells
1. Open the table you want to wrap, select the cell you want to wrap, and click Right click and select "Format Cells".
#2. In the pop-up dialog box, click on the "Alignment" option and check "Automatically wrap". Others can be set according to your actual situation. Finally Click "OK" to save.
#3. You can see that the cells to be wrapped are automatically wrapped.
The above is the detailed content of What is the Excel line break shortcut key?. For more information, please follow other related articles on the PHP Chinese website!