Hi Gord,
Would you pease tell me what is a "great whack"?
I'm not trying to be rude, i really don't know.
thx
Dave
Gord Dibben Wrote:
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!


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=495657