Adding Space Between Rows?

  • Thread starter Thread starter Joshua
  • Start date Start date
J

Joshua

I've imported a vocabulary list from Word into Excel, with one entry per
cell in column A, and I want to put a little space between the rows for
readability. In this case, I can't insert blank rows between the entry rows
because of the contents of another column. Is there a way to make Excel
increase the cell padding? Thanks to anyone who can help solve this
quandary.
 
Joshua,

You can increase the row height. Select the rows (drag through the row
headers, or press Ctrl-a for all rows). now drag any row header border
downward a little. They should all increase in height. Alternatively, you
could select the column, reduce the font size, then change the zoom (zoom
box in standard toolbar) to make stuff larger. If you're going to print
this, you'd want to check that too.
 
Setting a specific row height won't work in this case because the contents
of the cells vary in length - some of the definitions are a single line
while others occupy several lines.

What I need, essentially, is the Excel equivalent of that formatting feature
in Word where you add a certain number of points/lines after each paragraph.
 
You could (temporarily) insert a new column: =A1&CHAR(10)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Joshua,

You could put an extra blank line after the cell contents by pressing
Alt-Enter. That will give you extra space after the stuff in the cell. If
you want to control the height of that space, include a space in the line,
select it, and change its font size.
 
Back
Top