I format cell using "Warp Text" to have my text within my cell width.
However, the height of the cell remain same resulted bottom line within cell
unable to read. I need to manual adjust cell height.

Can I block cells and perform auto cells' height adjustment ?

Hi,

If there are no merged cells in the range then put your mouse between the
row numbers and when the mouse changes to a two headed arrow double click it.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Solex" wrote:

I format cell using "Warp Text" to have my text within my cell width.
However, the height of the cell remain same resulted bottom line within cell
unable to read. I need to manual adjust cell height.

Can I block cells and perform auto cells' height adjustment ?

Hi, I need it to be auto adjust cell height whenever i entered text into the
cell. I have a big order sheet for my customers to place their order and
enter remarks. Sometime people typed alot within a cell.

I need it to auto adjust after user pressed "Enter" button when they
completed a single cell entry. Thanks

"Shane Devenshire" wrote:

Hi,

If there are no merged cells in the range then put your mouse between the
row numbers and when the mouse changes to a two headed arrow double click it.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Solex" wrote:

I format cell using "Warp Text" to have my text within my cell width.
However, the height of the cell remain same resulted bottom line within cell
unable to read. I need to manual adjust cell height.

Can I block cells and perform auto cells' height adjustment ?

If you autofit the rowheight, then excel should continue to autofit that
rowheight if you make changes.

But if you've specified the rowheight yourself (either dragging the row height
line or using the menus), then excel will respect that.

But you should just autofit the rowheight once more to get it to work.

(Either doubleclick on that row height line or use the menus.)

Solex wrote:

Hi, I need it to be auto adjust cell height whenever i entered text into the
cell. I have a big order sheet for my customers to place their order and
enter remarks. Sometime people typed alot within a cell.

I need it to auto adjust after user pressed "Enter" button when they
completed a single cell entry. Thanks

"Shane Devenshire" wrote:

Hi,

If there are no merged cells in the range then put your mouse between the
row numbers and when the mouse changes to a two headed arrow double click it.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Solex" wrote:

I format cell using "Warp Text" to have my text within my cell width.
However, the height of the cell remain same resulted bottom line within cell
unable to read. I need to manual adjust cell height.

Can I block cells and perform auto cells' height adjustment ?

--

Dave Peterson