# How to Use AutoFit Shortcut in Excel (3 Suitable Methods)

Get FREE Advanced Excel Exercises with Solutions!

While inputting anything in the cell in Excel, sometimes we need to increase the Columnâ€™s width and Rowâ€™s height depending on cell values. We can easily increase the Columnâ€™s width and Rowâ€™s height by using the AutoFit shortcut in Excel. Weâ€™ll use the keyboard shortcut, double-click, and Ribbon to AutoFit columns and rows. Today, in this article, Iâ€™ll show you three suitable ways by which you can learn how to use AutoFit shortcuts in Excel effectively with appropriate illustrations.

## How to Use AutoFit Shortcut in Excel: 3 Suitable Methods

Letâ€™s assume a scenario where we have information about the Student Names of a school and their marks in Botany and Zoology are given in Column B, Column C, and Column D respectively. In our dataset, weâ€™ll use AutoFit shortcuts in Excel. Hereâ€™s an overview of the dataset of todayâ€™s task.

### 1. Apply the Keyboard Shortcuts to AutoFit in Excel

In our dataset, we can apply AutoFit by using the keyboard shortcuts in two ways. The first one is AutoFit row height and another is AutoFit column width.

We will learn both ways in this section.

#### 1.1 Use the Keyboard Shortcut to AutoFit Row Height in Excel

To AutoFit row height in Excel by using the keyboard shortcuts, follow the instructions below.

Steps:

• First, select cell B4 to cell D13.

• After that, press the following on your keyboard,

Alt + H + O + A

• Press the buttons one after one, not simultaneously.
• After pressing the above four buttons on your keyboard, youâ€™ll get the desired output, which has been given in the below screenshot.

Read More: How to AutoFit in Excel

#### 1.2 Perform the Keyboard Shortcut to AutoFit Column Width in Excel

After learning to AutoFit row height in Excel by using the keyboard shortcuts, here weâ€™ll learn how to AutoFit column width by using the keyboard shortcuts. Weâ€™ll apply to AutoFit features in column B, column C, and Column D. Letâ€™s follow these steps below to learn!

Steps:

• To AutoFit columns in Excel by using the keyboard shortcuts, first, select cell B4 to cell D13.

• After selecting the columns, press the below buttons on your keyboard one after one, not simultaneously. The buttons are:

Alt + H + O + I

• Another way is to AutoFit columns by using the keyboard shortcuts,

Alt + O + C + A

• After completing the above process, you will be able to AutoFit column width in Excel.

### 2. Use the Double Click Option to AutoFit Shortcut in Excel

After learning AutoFit shortcuts by using the keyboard shortcuts, in this method, we will learn how to AutoFit row height and column width in Excel by performing the double-click option on the Mouse. It is the easiest way to AutoFit column width and row height.

#### 2.1 AutoFit Row Height in Excel

From our dataset, we want to AutoFit row 9 where Potterâ€™s marks in Botany and Zoology are situated. To AutoFit row height in Excel, letâ€™s follow the steps below.

Steps:

• First, select row 9.

• After selecting row 9, place your cursor on the bottom-left of row 9. Then the twoâ€“directional array sign pops up.

• While a two-directional array sign pops up, press double left-click on your Mouse.
• After performing the above process, you will be able to AutoFit row 9 which has been given in the below screenshot.

Read More: How to Change Cell Size in Excel

#### 2.2 AutoFit Column Width in Excel

After performing the row operation, weâ€™ll learn how to AutoFit column width in Excel. We want to AutoFit column D by using the double click on Mouse. Letâ€™s follow the instructions below.

Steps:

• First, select column D.

• Now, place your cursor on the right side of column D. Then the two-directional array sign pops up.

• After that press double left-click on your Mouse and you will get your desired output which has been given in the below screenshot.

### 3. Apply the Ribbon Option to AutoFit Shortcut in Excel

In this method, weâ€™ll learn how to use AutoFit shortcuts in Excel by using the Ribbon.Â It is the most useful method because we are using this method frequently in our Excel spreadsheet.

#### 3.1 Use Ribbon Option to AutoFit Row Height in Excel

In this sub-method, we want to AutoFit row height by using the Ribbon. Weâ€™ll AutoFit the row height of row 6 where Williumâ€™s obtaining marks in Botany and Zoology are situated. To AutoFit row height, follow these steps below to learn!

Steps:

• First, select row 6.

• After selecting row 6, from your Home tab, go to,

Home â†’ Cells â†’ Format â†’ AutoFit Row Height

• After clicking on the AutoFit Row Height from the Cell Size window, you will be able to AutoFit row 6 which has been given in the below screenshot.

#### 3.2 Apply Ribbon Feature to AutoFit Column Width in Excel

Now, weâ€™ll AutoFit column width by using the Ribbon. Letâ€™s follow the instructions.

Steps:

• First, select column C.

• Now, from your Home tab, go to,

Home â†’ Cells â†’ Format â†’ AutoFit Column Width

• After selecting AutoFit Column Width from the Cell Size window, you can get your desired output.

## Things to Remember

ðŸ‘‰ While using keyboard shortcuts to AutoFit row height, press the buttons one after one not simultaneously and the buttons are,

Alt + H + O + A

ðŸ‘‰ You can use keyboard shortcuts to AutoFit column width,

Alt + H + O + I

ðŸ‘‰ Another way is to use keyboard shortcuts to AutoFit column width,

Alt + O + C + A

## Conclusion

I hope all the suitable methods mentioned above for AutoFit rows and columns will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF