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

How to Space Down in Excel: 3 Ways

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.


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

  • What we have to do now is Adjust the Row Heights, manually or by double-clicking on the row border.

That’s it. Easy.

Read More: How to Make Excel Go to the Next Line Automatically

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


  • First, click on cell F5 and type the following formula.

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 for the rest of the series.

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

Read More: How to Do a Line Break in Excel 

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.


  • First, select the data range and press CTRL+H and a dialogue box will pop up. In the dialogue box type a comma (,) in the 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: Find and Replace Line Breaks in Excel

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.

Download Practice Workbook


That’s all for the article. These are 3 different methods 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

<< Go Back to Line Break in Excel | Text Formatting | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Mahbubur Rahman
Mahbubur Rahman

MAHBUBUR RAHMAN is a leather engineer with a talent for Excel and a passion for VBA programming. To him, programming is like a time-saving wizard, making data manipulation, file handling, and internet interactions a breeze. His skill set extends to SPSS, STATA, Deep Neural Networks, and Machine Learning. Holding a B.Sc in Leather Engineering from Khulna University of Engineering & Technology, he's shifted to become a content developer. In this role, he crafts technical content centred around Excel... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF