Office Tip: how to type multiple lines in an Excel cell

Office-Tricks-6

Did you know that it’s possible to write multiple lines in an Excel cell? You can type Enter without necessarily having to move to the cell below. As part of our Office Tips series, here’s a little Excel tip to get you familiar with this feature.

Excel isn’t designed to input text, but directly annotating a spreadsheet is much more convenient than creating an additional complementary document.

When typing long sentences in Excel, the program displays all the text in a single line, even if it’s really long.

Long sentence Excel

For some spreadsheets, making multiple lines of text in the same cell gives the document a more spacious layout.

Here’s how to make a new line of text in a cell, as shown in the image below.

Alt Enter Excel

Click on the cell that you want to add the text to. Then, simply hold down the Alt button and press Enter whenever you want to make a new line.

Alt Enter Excel

You can repeat this process as many times as you want in order to have multiple lines of text in a single cell. The height of the cell increases as you add more lines

If you want to adjust the height of the cell, go to the left of the screen, where it shows the row number (in our example, row 3). Then, click on the line that separates the two rows and drag it up or down holding the left mouse button.

For the next tip in our Office Tips series, I’ll explain how to lock and protect cells in Excel to avoid any accidental modifications.

Read more articles from our Office Tip series:

Type faster by replacing one word with another

Add page numbers to your Word document

Access your Word, PowerPoint and Excel documents online

Restore or minimize the Ribbon interface in Word and Excel

Use tabs in Word, Excel and PowerPoint

Follow me on Twitter: bbrassart

Loading comments

Latest articles

Top downloaded apps

See full top