Forum Discussion
Autofit Columns to Data Not Headings
Hello, I have a large table with some long headers, but small data e.g. header = "Suggested Order Quantity", data = single figures. I would like to wrap the text in the headers, and then autofit ...
I came to this thread thinking of the same question. Right now, in office 365 Excel, I can highlight the row filled with data (empty columns may not be affected), and then go to the ribbon, clicking Home > Cells > Format > Autofit column width, and all columns will be auto adjusted. If any column remains the same, that could be due to empty cells or cells with empty spaces. Simply highlight another row with data you want and autofit likewise.