Excel wrapped rows, want automatically leave some space bottom of

G

Garth

In Excel I have rows with wrapped text in some of the columns. I would like
to improve the look by adding a small amount of space at the base of each
row. As the rows are different heights due to the wrapping, stretching
afterwards doesn't do it. What I need is something like the spacing after in
the paragraph options in Word. I thought it would be quite obvious but
clearly not. Does anyone know how I can do this? Please don't suggest
putting an empty row between every row...
 
M

Ms-Exl-Learner

Assume that you are having one of the data in Cell A1

Copy and paste the below formula in B1 cell.
=A1&CHAR(10)

Now copy the B1 cell and do Right Click>>Paste Special>>Values>>Ok. Place
the cursor in B1 cell and press F2 and give Enter.

Remember to Click Yes, if this post helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
White space above heading inconsistently applied 1
Can I automatically add space after ea. row ("Space After" in Word 0
Compressing row heights for a spreadsheet with wrapped text 2
Increase spacing above contents of cell 0
Problem with MS Word paragraph and character styles: format getting messed up 2
Set row height, but allow wrap text 0
Insert Rows Below 6

Top