You are currently viewing How to write multiple lines in a cell in Excel

How to write multiple lines in a cell in Excel

In excel sheets we may also be interested in maximizing on space apart from just recording the data from various findings, we can maximize on space by either writing two lines on a single cell or using shorter words. Writing two lines on a particular cell does not only save on space but also helps to congest the cells so as the data of the same type may not lose meaning when separated.

Apart from maximizing space on excel sheets; writing content on other text editors does not only involve writing to finish the task but also to check on some of the writing requirements. When we come to the issue of wording, we may need to maximize the usage of space to fit a lot of content on a single page or a line.

For us to write multiple lines in a single cell there are a series of steps we must adhere to for us to get to a successful result. Some of the steps are explained below with an example.

Step 1

In your computer search for Microsoft Excel and click to open it. An excel sheet will automatically open upon clicking on Microsoft Excel. On the menu bar, click on the file to create a new blank excel sheet. In this excel sheet, we won't be interested in inserting a lot of content into different columns as in the case of other excel sheets we have dealt with. Since we are not inserting many columns, on the first row enter a character of your choice. As you can see, the character has already taken up the whole space of the first cell. Now we will have to create a new line, just on the cell with your first character, click on ALT+ENTER functions at the same time.

After you click on those two functions, you will immediately see a new line has been created below your first character. Enter another character on the newly created line. The two characters will all appear on cell B1. Repeat the whole process until you get multiple characters as in the case below.