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.
Read More: How to Reset Cell Size to Default 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.
Read More: How to Make Excel Cells the Same Height and Width
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.
Read More: How to Change Cell Size Without Changing Whole Column
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
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
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.