Row height keeps expanding in Excel 2010

If you look further down in the questions, you will see the the same issue is mentioned with 6 people having the same problems. If you look at Excel 2007 you will see that the same bug was present. This is a bug in the program that Microsoft has not addressed. It is time they acknowledged and addressed it. I rebuilt in Excel 2010 a spreadsheet that was driving me crazy in Excel 2007 and the problem went away for 10 months. Recently it reappeared. I know of nothing I did that would make it reappear, but obviously something changed somewhere. 

I was mistaken - the problem arose in 2010, not 2007. I unregistered and re registered and this did not resolve the problem. Here is exactly what happens: if I delete row 33, no change. If I delete row 32 and 33, row 49 expands. If I delete 32, 33, 34, rows 49 and 50 expand, etc. Always starts 17 rows below, expands one row less than the number deleted. Maybe that will help.

Revision 3: I opened and closed the program repeatedly, each time deleting various rows, and found that the pattern is not regular. Sometimes more rows were expanded than deleted, and the distance down varied 17, 28, 60, 18, etc, apparently at random. Because the original spreadsheet was imported from Excel 2003, I rebuilt the spreadsheet in Excel 2010 toward the end of April and have had no problems for a little over 6 months, then the glitch just reappeared.

If you look further down in the questions, you will see the the same issue is mentioned with 6 people having the same problems. If you look at Excel 2007 you will see that the same bug was present. This is a bug in the program that Microsoft has not addressed. It is time they acknowledged and addressed it. I rebuilt in Excel 2010 a spreadsheet that was driving me crazy in Excel 2007 and the problem went away for 10 months. Recently it reappeared. I know of nothing I did that would make it reappear, but obviously something changed somewhere.

Try the steps below and check if it helps:

1. Open Excel 2010.
2. Click File – Options.
3. Select [Advanced] tab, turn on [Cut, copy and sort inserted objects with their parent cells] option. (In [Cut, copy and paste] section).

You may also refer to the link below to resize the column width and row height:

http://office.microsoft.com/en-us/excel-help/change-the-column-width-and-row-height-HP010342239.aspx

No macros.

Any macros running on the background?

jpgpinto

www.excel-user.blogspot.com