How To Auto Fit Rows and Columns

A quick method to auto-fit the height of all rows and length of all columns in your spreadsheet.

---

Auto Fit Rows and Columns

1. Click on the intersection header of rows and columns to select all rows and columns simultaneously.

2. Double-click on the border of any row header to auto-fit all rows to their content height.

3. Double-click on the border of any column header to auto-fit all columns to their content length.

4. Deselect rows and columns by clicking anywhere on the sheet.

The following animation demonstrates the above steps.