Yes this is a bug in Excel, but there is an easy work around
This is achieved by Selecting the entire spreadsheet. (click on then top left corner button), then Double clicking the line in the margin in between the two rows.
This will auto resize for you
Between which two rows? THe row above the row I'm trying to autofit or the row below the row I'm trying to autofit?
It shouldnt matter
choose the row above please
When I tried it on both row above and below, it did increase the height of the row, but not nearly enough to accommodate the text I had typed in.
you double clicked?
Yes, I just tried again. Do you mean in the margin where the line numbers are? When I put my mouse over the line between the rows in the area where the line numbers are, a cross appears and I double click. Is that where you are talking about double clicking?
on the horizontal line where the numbers are please
Yes, that's where I am double clicking
can you upload the excel spread sheet to this link pleas
and provide me the download link?
I can look if anything in it is causing problems
OK. I have to leave now for an appointment. Can we continue this tomorrow? You'll have to tell me how to upload a document.
yes we can