Autofit Alternatives in Excel
There are a couple of alternatives for Autofit in Excel. Some of them are described below:
Wrap Text
It will fit your text in that particular cell. It will increase the row height to fit the text but the column width will remain the same. To use this alternative follow the below steps:
Step 1: Select your cells to wrap.
Step 2: Click on Wrap Text on the Home tab in the Alignment group.
Wrap Text from Keyboard Shortcut:
- Press ALT >- H >-W
Shrink to Fit
To shrink the contents of a cell so that they fit in the current column width follow the below steps:
Step 1: Select desired cells.
Step 2: Click on Format in the Cells group in the Home tab.
Step 3: Click on Format Cells. Below dialog box will appear.
Step 4: Click on ‘Shrink to fit’.
Step 6: Verify Changes.
The text size is shrunk to fit the column.
How to AutoFit in Excel? – Change the Column Width and Row Height
AutoFit is a feature in Excel that helps you to quickly adjust the row height or column width so that your data/text fits completely into the cell. Also, In AutoFit you don’t have to manually specify the row height and column width. It will Automatically figure out how much expansion is needed. to fit the text in the cell.
Contact Us