Channel | Publish Date | Thumbnail & View Count | Actions |
---|---|---|---|
| 2022-12-08 16:00:22 | ![]() 30,264 Views |
Learn how to insert line break in Excel. Essentially, how to insert a new line in Excel. That is, split multiple lines in a cell.
Note that, on the keyboard, pressing Ctrl + J will enter a line break character.
Here are the steps.
1) Select all rows.
2) Ctrl + H
3) /”Find what/” set to comma (,)
4) /”Replace with/” press Ctrl + J
5) Replace All
6) OK
7) Close
8) Home — Alignment — Wrap Text (toggle it twice)
#microsoft #excel #exceltips #tips #exceltricks #tricksandtips
Please take the opportunity to connect and share this video with your friends and family if you find it useful.