How to AutoFit Cell Width and Height to Cell Data in Excel
Many times, our text doesn’t fit perfectly in Excel cells. To adjust the size without having to drag and find the ideal fit, a double-click can take care of it for you. With a quick click, you can AutoFit your cells so that your text fits comfortably within your spreadsheet, and doesn’t trail off into the next cell.
See the video demonstration above and steps below.
•In your spreadsheet, find the cells where the text doesn’t fit.
•Say for instance your text in cell C3 is cut off by the text in D3.
•Go to the column title bar. •Hover over the space between columns C and D.
•There is a thin grey line between the columns.
•A new icon should appear.
•While the icon is present, double click and your column will AutoFit the text in column C. It will jump and readjust.
To AutoFit your text in row, follow these same steps.
