Excel shortcuts

19 Autofit Shortcuts in Excel You Need to Know

If you're an Excel power user, you know that there are many ways to get things done in the program. One of the most useful features is the ability to autofit columns and rows to their contents. This can save you a lot of time when working with large data sets.

There are several ways to autofit columns and rows in Excel. In this article, we'll show you 19 of the best autofit shortcuts that you need to know.

1. To autofit a column, select the column that you want to autofit. Then, double-click on the right-hand border of the column header.

2. To autofit multiple columns, select the columns that you want to autofit. Then, hold down the Shift key and double-click on the right-hand border of any of the selected column headers.

3. To autofit all columns on a worksheet, click the Select All button in the upper-left corner of the worksheet. Then, double-click on the right-hand border of any column header.

4. To autofit a row, select the row that you want to autofit. Then, double-click on the bottom border of the row header.

5. To autofit multiple rows, select the rows that you want to autofit. Then, hold down the Shift key and double-click on the bottom border of any of the selected row headers.

6. To autofit all rows on a worksheet, click the Select All button in the upper-left corner of the worksheet. Then, double-click on the bottom border of any row header.

7. To autofit a column to its contents, select the column that you want to autofit. Then, click the Home tab on the Ribbon. In the Cells group, click the Format button. From the drop-down menu, choose AutoFit Column Width.

8. To autofit multiple columns to their contents, select the columns that you want to autofit. Then, click the Home tab on the Ribbon. In the Cells group, click the Format button. From the drop-down menu, choose AutoFit Column Width.

9. To autofit all columns on a worksheet to their contents, click the Select All button in the upper-left corner of the worksheet. Then, click the Home tab on the Ribbon. In the Cells group, click the Format button. From the drop-down menu, choose AutoFit Column Width.

10. To autofit a row to its contents, select the row that you want to autofit. Then, click the Home tab on the Ribbon. In the Cells group, click the Format button. From the drop-down menu, choose AutoFit Row Height.

11. To autofit multiple rows to their contents, select the rows that you want to autofit. Then, click the Home tab on the Ribbon. In the Cells group, click the Format button. From the drop-down menu, choose AutoFit Row Height.

12. To autofit all rows on a worksheet to their contents, click the Select All button in the upper-left corner of the worksheet. Then, click the Home tab on the Ribbon. In the Cells group, click the Format button. From the drop-down menu, choose AutoFit Row Height.

13. To autofit a column to its contents, select the column that you want to autofit. Then, hold down the Ctrl key and press the + key (on the numeric keypad).

14. To autofit multiple columns to their contents, select the columns that you want to autofit. Then, hold down the Ctrl key and press the + key (on the numeric keypad).

15. To autofit all columns on a worksheet to their contents, click the Select All button in the upper-left corner of the worksheet. Then, hold down the Ctrl key and press the + key (on the numeric keypad).

16. To autofit a row to its contents, select the row that you want to autofit. Then, hold down the Ctrl key and press the + key (on the numeric keypad).

17. To autofit multiple rows to their contents, select the rows that you want to autofit. Then, hold down the Ctrl key and press the + key (on the numeric keypad).

18. To autofit all rows on a worksheet to their contents, click the Select All button in the upper-left corner of the worksheet. Then, hold down the Ctrl key and press the + key (on the numeric keypad).

19. To autofit a column to its contents, select the column that you want to autofit. Then, hold down the Ctrl key and press the Spacebar.

These are just a few of the autofit shortcuts that you can use in Excel. Experiment with them to see which ones work best for you. And be sure to check out our other Excel tips and tricks.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.