How to Space Down in Excel (3 Methods)

In most office applications adding a new line, paragraph or space down is not a problem. But Microsoft Excel is different in this case. We will see how to space down in Excel in 3 different methods. For your better understanding, we will use a sample dataset.

How to space down in Excel by shortcut


Download Practice Workbook


3 Ways to Space Down in Excel

In this article, we will see a shortcut, then a formula, and the Find and Replace option to space down in Excel.


Method 1: Using Shortcut to Space Down in Excel

As you can see, we have information about some movies, but the information sentences are in a single cell displayed as a line. We want this info in that specific cell but in different paragraphs.

Steps:

  • Double Click on Cell C5 and click before the text 1994 as we want to space it down and press ALT+ENTER.

How to space down in Excel by shortcut

  • As a result, the line will move to the next paragraph, this time again press ALT+ENTER pointing the cursor before the word American.

How to space down in Excel by shortcut

  • After that, press the ENTER key and we get the following result.

That’s it. Easy.

Read More: How to Add Space Between Text in Excel Cell (4 Easy Ways)


Method 2: Space Down Using Formula

When we have Text in different columns but we want to display them in a single cell in different paragraphs by spacing down, we can use this method. Suppose, we have a dataset like the image below. We will use the CHAR function here for joining text.

How to space down in Excel by CHAR function

Steps:

  • First, click on cell F5 and type the following formula.
=A2&CHAR(10)&B2&CHAR(10)&C2&CHAR(10)&D2&CHAR(10)&E2

How to space down in Excel by formula

CHAR(10) denotes a line break. Here, we’ve concatenated the text with a line break to space down within the final result.

  • Now, press the ENTER key.

  • What we have to do now is, just go to HOME > Wrap Text.

How to space down in Excel by CHAR function

  • We will get the result as follows.

How to space down in Excel by formula

  • Now, we can drag down to AutoFill rest of the series.

  • After adjusting row heights our final result will be like the image below.

Read More: How to Add Blank Space Using Excel Formula (6 Methods)


Similar Readings


Method 3: Space Down in Excel after a Specific Character

Another easy way to space down in Excel is, the Find and Replace option. We’ll use that option to space down after a particular character in Excel.

Steps:

  • First, select the data range and press CTRL+H and a dialogue box will pop up. In the dialogue box will type a comma (,) in Find what box and press CTRL+J in the Replace with box.

Here, we are replacing all the commas with a line break.

How to space down in Excel by find and replace

  • After, clicking Replace all we will find the output like the following image.

How to space down in Excel by find and replace

  • Finally, adjust row heights and our result will be ready.

Read More: How to Find and Replace Space in Excel (5 Methods)


Practice Section

The single most crucial aspect in becoming accustomed to these quick approaches is practice. As a result, we’ve attached a practice workbook where you may practice these methods.


Conclusion

That’s all for the article. These are 3 different methods on how to space down in Excel. Based on your preferences, you may choose the best alternative. Please leave them in the comments area if you have any questions or feedback.


Related Articles

Mahbub
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo