You want the whitespace at the top or bottom of the cells?

To maintain Autofit and have whitespace you can add an ALT + ENTER ahead of or
behind the text.

Try this.

Select a cell with autofit row.

F2 to edit.

Point to start of text and hit ALT + ENTER to add a blank line.

Also make sure the cell is set to "Wrap Text"

If you have a great whack to do, a macro could be provided.


Gord Dibben Excel MVP


On Thu, 22 Dec 2005 15:17:02 -0800, criticalpath
wrote:

I need to add white space to each row of a spreadsheet where height is
auto-adjusted. A feixed row height will not work here. Please help!