That is not AutoFill.........it is AutoComplete.

If you don't want the rows to increase in height, turn off Autofit by giving
the row a defined height.

Also disable "wrap text" for the cells.


Gord Dibben MS Excel MVP

On Sun, 7 Mar 2010 17:30:47 -0800 (PST), trvlnmny
wrote:

I am using Excel 2003 and W XP.
I have the height of my rows at 12.75. Some rows are larger because
data in a cell on those rows needs 2 lines. When I am entering data
in a row that is only 12.75 high and I type a couple of characters
Auto Fill kicks in and shows me the entire contents for the cell. I
then hit Enter and Auto Fill completes. The problem is that even
though the data is only 1 line in length the height of the row is
doubled to 25.5. I do not want this to happen, how can I stop it?
This also happens if the data I want is in the cell above mine and
that cell is only 12.75 high and I do a drag and drop the height of my
row is doubled to 12.75.
Thanks for any and all help.