How to Insert Line Break in Excel - Excel Tips and Tricks

Published: 08 December 2022
on channel: Rabi Gurung

30,116

1.5k

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

Watch video How to Insert Line Break in Excel - Excel Tips and Tricks online without registration, duration hours minute second in high quality. This video was added by user Rabi Gurung 08 December 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 30,116 once and liked it 1.5 thousand people.

9,414

262

00:00:00