How to Use AutoFit Shortcut in Excel (3 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 autoFit shortcuts in Excel. We’ll use the keyboard shortcut, Double click method, and Ribbon Command to autoFit columns and rows. Today, in this article, I’ll show you three suitable ways by which you can get to learn how to use autoFit shortcut in Excel effectively with appropriate illustrations.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


3 Suitable Ways to AutoFit Shortcut in Excel

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 our 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 of the 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.

Use the Keyboard Shortcut to AutoFit Row Height in Excel

  • 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 desired output which has been given in the below screenshot.

Use the Keyboard Shortcut to AutoFit Row Height in Excel


1.2 Perform the Keyboard Shortcut to AutoFit Column Width in Excel

After learning to autoFit rows height in Excel by using the keyboard shortcuts, here we’ll learn how to autoFit columns 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 of all, select cell B4 to cell D13.

Perform the Keyboard Shortcut to AutoFit Column Width in Excel

  • 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 columns width in Excel.

Read More: How to Adjust Column Width in Excel (7 Ways)


Similar Readings


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 Mouse. It is the easiest way to autoFit columns width and rows 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.

Apply Double Click to AutoFit Row Height in Excel

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

Apply Double Click to AutoFit Row Height in Excel

  • 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.


2.2 AutoFit Column Width in Excel

After performing the row operation, now, we’ll learn how to autoFit columns width in Excel. We want to autoFit column D by using the double click on Mouse. Let’s follow the instruction below.

Steps:

  • First of all, select column D.

Perform Double Click to AutoFit Column Width in Excel

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

Perform Double Click to AutoFit Column Width in Excel

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

Read More: How to Change Column Width in mm in Excel (A Step-by-Step Guideline)


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 Command. 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 Command. 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.

Use Ribbon Command to AutoFit Row Height in Excel

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

Home → Cells → Format → AutoFit Row Height

Use Ribbon Command to AutoFit Row Height in Excel

  • 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.

Use Ribbon Command to AutoFit Row Height in Excel


3.2 Apply Ribbon Feature to AutoFit Column Width in Excel

Now, we’ll autoFit column width by using Ribbon Command. Let’s follow the instruction.

Steps:

  • First of all, select column C.

Apply Ribbon Command to AutoFit Column Width in Excel

  • Now, from your Home Tab, go to,

Home → Cells → Format → AutoFit Column Width

Apply Ribbon Command to AutoFit Column Width in Excel

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

Read More: How to Change Cell Size without Changing Whole Column (2 Methods)


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 of the suitable methods mentioned above to 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.


Related Articles

Md. Abdur Rahim Rasel

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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo