Auto Cell Height Adjustment for text entered


S

Solex

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

Advertisements

S

Shane Devenshire

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

Solex

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
 
Ad

Advertisements

D

Dave Peterson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top