How to write multiple lines in a cell in Excel

In excel sheets we may also be interested in maximizing space apart from just recording the data from various findings, we can maximize 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 that 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 checking 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.

Method 1: Using Excel Shotcut

On your computer search for Microsoft Excel and click to open it. An excel sheet will automatically open upon clicking on Microsoft Excel.

1. On the menu bar, click on the file to create a new blank excel sheet.

2. 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 word of your choice.


3. 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.

4. 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.

5. Repeat the whole process until you get multiple characters as in the case below.

Method 2: By using the Wrap Text Feature

1. Click on any cell

2. Navigate to home

3. Click Wrap Text

4. Enter the information on the cell. A new line will be created automatically depending on the size of the cell

%d bloggers like this: