If that happens, AutoFit Row Height can help you adjust your rows. When you import data, information in your spreadsheet can sometimes get cut off in the process, or you might end up with certain rows that are awkwardly sized.

However, the feature can come in handy when you’re importing text from another document to your spreadsheet. As mentioned, though, AutoFit Row Height isn’t as commonly used as AutoFit Column Width because Excel will generally automatically increase the height of a row to accommodate wrapped text (text split into multiple rows) or large font. When you use the feature, the right boundary of every cell stretches to just beyond the last character in the longest cell.ĪutoFit Row Height stretches every cell in a row so that it’s just tall enough to display all the information inside of it. It works great if you have a spreadsheet where certain cells in a column have a lot of information in a single line. The AutoFit Column Width option is more common than the AutoFit Row Height option.

AutoFit Row Height extends the height of a row so all the information in the tallest cell is visible.

AutoFit Column Width expands the length of a column so you can see all the cell contents in the longest cell.

Specifically, there are two different AutoFit types:

Without AutoFit, you would have to manually alter each column or row by clicking on and holding its right or lower border and dragging it to your intended size or putting in specific measures for width or height. It helps you make sure that all the data in every cell group is clearly visible. AutoFit is a feature in Excel that lets you easily change the size of one or multiple columns or rows on a spreadsheet.

Change row to column in excel