Mahbubur Rahman
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.
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.
- As a result, the line will move to the next paragraph, this time again press ALT+ENTER pointing the cursor before the word American.
- 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 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.
Steps:
- First, click on cell F5 and type the following formula.
=A2&CHAR(10)&B2&CHAR(10)&C2&CHAR(10)&D2&CHAR(10)&E2
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.
- We will get the result as follows.
- 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
- How to Add Space between Numbers in Excel (3 Ways)
- Add Space between Rows in Excel
- How to Space Rows Evenly in Excel (5 Methods)
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.
- After, clicking Replace all we will find the output like the following image.
- 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.
