Cells increasing in size

J

John W.

How can I keep the cells the original size? When I type
anything into them, the cells increase in height.
Instead of them being a quarter inch high, they become 2
or 3 inches high.

Thanks,
John
 
M

Mark Graesser

Hi John
If you don't have word wrap on then the cells shouldn't change size. If you are using word wrap then Excel will fit the row height to the text unless you have preset the row height

After you have set the cells to use word wrap, select the row and go to Format>Row>Height and enter a specific number. Mine is usually 15

This will lock the selected row's height to that number

Good Luck
Mark Graesse
[email protected]
Boston M

----- John W. wrote: ----

How can I keep the cells the original size? When I type
anything into them, the cells increase in height.
Instead of them being a quarter inch high, they become 2
or 3 inches high.

Thanks
Joh
 
Top