![]() ![]() ![]() Through testing, I discovered that this only occurred when I was trying to readjust merged cells that also had the text wrapping format activated. Pretty cool, huh? The ProblemĪre you a power user of the double-click column/row auto-adjust feature? Well I am and there have been instances where I double-click to AutoFit a row height and Excel does nothing! After years of being bugged with this, I finally had enough and decided to figure out what was causing me this grief. If the entire row is empty then AutoFit will adjust to your default row height ( NOTE: using AutoFit on an empty column will not adjust that column back to its default width). ![]() If there is data in any of the cells in your target column/row, the AutoFit feature will extend so that every cell is showing the entirety of its content. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |