{"id":73525,"date":"2019-09-23T13:30:29","date_gmt":"2019-09-23T11:30:29","guid":{"rendered":"http:\/\/onsoftware.en.softonic.com\/?p=73525"},"modified":"2025-07-01T21:30:40","modified_gmt":"2025-07-02T04:30:40","slug":"office-tip-how-to-type-multiple-lines-in-an-excel-cell","status":"publish","type":"post","link":"https:\/\/cms-articles.softonic.io\/en\/office-tip-how-to-type-multiple-lines-in-an-excel-cell\/","title":{"rendered":"How to insert multiple lines into the same Microsoft Excel cell"},"content":{"rendered":"\n

Microsoft Excel<\/strong> has become such a popular spreadsheet application thanks to the numerous advanced features it provides to users in the know. One of the best tricks to learn is how to add several lines into the same cell on your spreadsheets. Adding additional data to a cell can be an excellent way to stay organized while making your information readily accessible. It is also an effortless way to attach written notes to the spreadsheet. <\/p>\n\n\n

\r\n
\r\n
\r\n
\r\n \"Microsoft\r\n <\/div>\r\n
\r\n Microsoft Excel<\/span>\r\n DOWNLOAD<\/a>\r\n <\/div>\r\n
\r\n <\/path><\/path><\/text><\/svg>\r\n <\/div>\r\n <\/div>\r\n
\r\n <\/span>\r\n <\/div>\r\n
\r\n \r\n <\/div>\r\n <\/a>\r\n <\/div>\r\n<\/div>\n\n\n\n

While Excel does not traditionally offer word processing, you can use the multiple lines trick to bypass this limitation<\/strong>. In just four steps and a few seconds, you will be customizing your Excel spreadsheets like a pro.<\/p>\n\n\n

  1. Choosing a spreadsheet cell to modify<\/h2>\"This

    First, you will need a spreadsheet that could use some additional formatting. You most likely already have one in mind before viewing this tutorial. Good reasons to modify a spreadsheet cell include adding notes, writing long strings of characters, or to organize the data in question. Once you have a specific cell in mind click<\/strong> on it to select it in Microsoft Excel.<\/p>\n<\/div><\/li>

  2. Adding new lines to the cell<\/h2>\"Wrapping

    Modifying the cell is as simple as holding down the alt key and pressing enter<\/strong>. If done correctly, your text cursor will start blinking on the line below. Like in any word processor, you are now free to type directly below the previous row of information. You can repeat the alt + enter technique as many times as you need on any given spreadsheet cell.<\/p>\n

    If you wish to dive deeper, there is a more comprehensive way to achieve comparable results using the wrap text feature in Microsoft Excel. This is perfect for when your cell already has a bunch of text without any of the nice formatting. Right-click on the cell you wish to modify and select Format Cells<\/strong> from the drop-down menu that appears. From the Format Cells window, click on the box that says wrap text<\/strong> under the alignment tab. Be sure to confirm your changes by clicking on OK before leaving this window.<\/p>\n<\/div><\/li>

  3. Adjusting the cell\u2019s height<\/h2>\"You

    As you continue to add more lines to the same cell, you may notice the formatting start to falter. Luckily, you can readjust the height of any cell to complement your recent changes. To do this, look on the left side of the screen for the panel that displays which row is selected in Excel.<\/p>\n

    In the picture above, the selected row is row 2. This is shown by the box highlighted in green. If you wish to make the cell larger, click the line between rows 1 and 2 and drag the mouse cursor up<\/strong> until the row is resized to your liking. To make the cell shorter again, grab the line between rows 2 and 3 and drag the mouse cursor down.<\/strong> Again, do this until the row is big enough to fit every line you added in the previous step.<\/p>\n<\/div><\/li>

  4. Saving your progress<\/h2>\"Always

    Since it is quite easy to forget to save your work when practicing a new skill, be sure to record your new progress before closing the program. It is especially important to save when you are making final adjustments before a deadline. To save the spreadsheet, click on File<\/strong> in the top left corner and select save on the dropdown menu that appears. Alternatively, you can click the floppy disk icon<\/strong> at the top of the screen if you have previously saved the spreadsheet before. After saving at least once, you can also toggle the autosave feature from the panel right next to the floppy disk icon.<\/p>\n<\/div><\/li><\/ol><\/div>