Ask Excel not to change cell format to auto wrap after using alt+e

P

philippe

Hi,
Everybody knows that when you've a line return (inserted using ALT+ENTER) in
a cell, Excel will change the cell format to "wrap" and adjust line height
consequently.

Now I would like to find a way to prevent Excel from reformating the cell
once I press Enter to validate my input.

Can anybody help ?
Thanks,
Philippe
 
G

Gord Dibben

Prior to entry of text and the alt + enters format the row to a fixed height.

This will turn off the autofit.


Gord Dibben MS Excel MVP
 
Top