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!

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!

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

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!

Hi Gord,
Thx for the enlightenment on the "great whack". Very interesting. :)
Thx again
Dave
Gord Dibben Wrote:
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!


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

Is there are way to do this without adding a whole line? I just want my
text to NOT sit right on the bottom border line of the cell. I don't
want to add a whole line to do that.

FWIW, my rows are going to be all different sizes. I want to be able to
auto size them without having to edit cells or add lines. If you can
"indent" cells from the left automatically in "cell formatting," can't
you dictate how much space appears at the bottom?

Also, I have a great whack to do! ;)

Thoughts, anyone?


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