Forum Discussion
MS Office 365 Excel
My query is why 'auto-format row height' is not working on the spreadsheet I am currently using?
it usualy helps alot if you discribe well you problem so people can see better what is happening.
what/where/when/how/what have you tried/
what/where/when/how/what have you tried/
Thanks. I highlight a whole row and then choose 'Format/AutoFit Row Height' but the row height reverts to standard single row height no matter how much is in the various cells. Is there a choice to enable/disable this function in 'Option' or elsewhere?
I have another question for you and a suggestion based on an assumption.
- The question: what is the general content of this spreadsheet?
- The assumption: from what you've described so far, it sounds like much, if not all, of the content is textual in nature, not numeric. It could be (my assumption) that you're using Excel because of its inherent and very helpful row and column layout more than for its ability to handle and process numeric data.
- IF that assumption is even close--i.e., if in fact you're using Excel primarily as a repository for text in a row and column layout--then my suggestion would be to use Word instead of Excel, because Word's Table facility gives you much more intuitive control over such things as column width, row height, with the latter "automatically" accommodating the amount of text present. If I recall correctly, Word can even accommodate basic math (e.g., sums of values in columns).
Thank you, I have managed to sort out the autoformat row height issue in Excel and will consider your recommendation to use Word for text only.
- do not think there is.
if you have two lines of text in a cell, heving selected your row try to activate "wrap text" button from alignment section from home ribbon if it will help. alt, h, w
and then autofit- Thanks, I'll give it a go. HNY.
