If you have long text to enter in an Excel cell or just require pushing text to next lines for clarity or for any other reasons, you may add a new line easily.
In this tutorial, I will show you ways of adding a new line in Excel cells.
The example of new line in a cell (Windows)
While entering the text in a cell and you want next words/characters in the new line then use this short key before writing the new words you want in the next line:
Alt + Enter
The demo below shows adding a line as I am typing a word. After the word “With” the “Alt + Enter” keys are pressed and we are writing into next line.
Insert new line in Mac OS
The short key for adding a new line in the Mac OS is:
CONTROL + OPTION + RETURN
So, follow these steps in the Excel for Mac:
- Double click in the cell where you want to add a new line
- Single click in the area/letter where you want the line break
- Press the above keys i.e. CONTROL + OPTION + RETURN
For existing text in new line (Windows)
If you want to add a line in existing text, double click in the cell and single click in the area or character from where you want the new line added. Then press Alt + Enter as shown in the interactive graphic below.
In the above demo, we have pre-written text in the cell. I just double-clicked after the word “With “ and press Alt + Enter to move the next words to the next line.
For Mac users, press the CONTROL + OPTION + RETURN.
The auto wrap option
If you require new lines added automatically as the text in the cell exceeds the width then you may use the Wrap Text option.
For that, you may select a cell, column etc. and press the Wrap Text button under the Alignment group in Home tab.
You may read about this option with screenshots in its tutorial here: Excel wrap text