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.
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.
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.
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:
Follow me on Twitter: bbrassart