How to use shortcut to add new line/line break in a cell in Excel?
In Excel, when you type a long data into a cell, the data will spill over into next blank cells at default. And this tutorial is talking about adding new lines as you need in a cell when you type the long text string.
To add new line breaks in a cell as you need in a cell, you just need to remember some hotkeys.
Place the cursor at the place of the cell you want add new line break, then press Alt + Enter keys simultaneously. Then you can see the new line break added into the cell.
Note: If your computer installed with Mac system, you can use the shortcut Control + Command + Return keys.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!