A large number of cells to deal with is a "great whack".

2 is a couple
3-5 is a few
6-9 is several
10-15 is a bunch
16 and over is a great whack

Adding the line feed is a manual cell by cell operation and could take a
while.

A macro could add a line feed to all cells in a selection with the click of a
button or shortcut key combo.


Gord


On Thu, 22 Dec 2005 21:20:10 -0600, Desert Piranha
<Desert.Piranha.20h3vm_1135308301.3099@excelforu m-nospam.com wrote:


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!