Adding Space Between Rows?

[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]

P.S. I'm using Excel 2000 in Windows XP.

 

[Frank Kabel]

Hi
why not increase the row heigth. Select all rows and goto format -
Rows - Height

 

[Earl Kiosterud]

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.

 

[Joshua]

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.

 

[Joshua]

I'm afraid that won't work in this case. See my response to Frank below.

 

[Frank Kabel]

Hi
this feature does not exist in Excel

 

[Niek Otten]

You could (temporarily) insert a new column: =A1&CHAR(10)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Earl Kiosterud]

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.