Rows in Excel keep expanding their height when I copy and paste

[JohnSull]

Rows in Excel keep expanding their height when I copy and paste om one lace to other in the same spreadsheet. I can roll the mouse wheel while holding down the Ctrl key to change the zoom and it goes back to the way it was. It is just irritating. It even happens when I save the spreadsheet using the floppy disk icon on the menu bar.

 

[My Aswer Is This]

If you copy a value from B5 which has a font size of 16
And then paste it into B1 and all the other cells in Row (1) has values with font size 10 the row height will change to allow for the font size. If you do not want this to happen choose paste values only.

 

[JohnSull]

I can fix it by holding the ctrl key and rolling the wheel on the mouse to change the zoom out and then in to reset it to normal view. It isn't that the problem is changing the zoom level it is expanding the rows and columns to a larger size and thye overlap each other.