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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

philippe - 08 Sep 2006 10:04 GMT

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

Reply to this Message

Gord Dibben - 08 Sep 2006 18:20 GMT

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

>Hi,
>Everybody knows that when you've a line return (inserted using ALT+ENTER) in
[quoted text clipped - 7 lines]
>Thanks,
>Philippe

Reply to this Message