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.