How to move words to next line in an Excel cell?
For the content in cell viewed neatly and orderly, we may need to move the words to next line as below screenshot shown, is there any way to handle it in Excel?
 |
 |
 |
Move words to next line by inserting line break
Move words to next line by Wrap Text
Move words to next line by inserting line break
You can use the shortcut to insert a line break to move the words to next line as you need.
Click at the location where you want to move the last words to the next line, and hold Alt, and press Enter key, then the words behind the cursor will be moved to the next line in the cell.
|
|
|
Move words to next line by Wrap Text
If you want to automatically move words to next line by the cell size, you can apply the Wrap Text utility.
Select the cells you want to use, and click Wrap Text under Home tab. See screenshots:
 |
|
 |
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!
