Home  >  Article  >  Topics  >  What is the Excel line break shortcut key?

What is the Excel line break shortcut key?

青灯夜游
青灯夜游Original
2019-06-05 16:32:2213598browse

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.

What is the Excel line break shortcut key?

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.

What is the Excel line break shortcut key?

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".

What is the Excel line break shortcut key?

#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.

What is the Excel line break shortcut key?

#3. You can see that the cells to be wrapped are automatically wrapped.

What is the Excel line break shortcut key?

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn