Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel wrapped rows, want automatically leave some space bottom of
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... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel wrapped rows, want automatically leave some space bottom of
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 ClickPaste SpecialValuesOk. Place the cursor in B1 cell and press F2 and give Enter. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Garth" wrote: 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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I automatically have a space after the content in an Excel cel | Excel Discussion (Misc queries) | |||
Excessive white space at bottom of form when printing. | New Users to Excel | |||
How do I repeat rows on the bottom of each sheet in excel? | Excel Worksheet Functions | |||
How do I clear blank space at the top of a word-wrapped text cell? | Excel Discussion (Misc queries) | |||
How do I automatically expand a merged cell with wrapped text? | Excel Discussion (Misc queries) |