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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

Similar Threads

Forced new line in a cell: Excel 2
How to prevent word wrap on a cell before line is filled 2
ALT + Enter and Wrap Text 3
Wrap text does not adjust row height in merged cells. 2
Make Excel 2003 auto upate cell caluclations 3
Can I auto format row height according to requirements of largest cell in row? 7
Text Wrap, Cell Height Does NOT Automatically Adjust 1
How to autofit row height for merged wrapped cells 3

Back
Top