Md. Abdur Rahim Rasel
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.
- 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.
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.
- 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
- How to Reset Cell Size to Default in Excel (5 Easy Ways)
- Make Excel Cells the Same Height and Width
- How to Autofit in Excel (7 Easy Ways)
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.
- After selecting row 9, place your cursor on the bottom-left of row 9. Then 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.
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.
- Now, place your cursor on the right side of column D. Then 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 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.
- 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 Ribbon Command. Let’s follow the instruction.
Steps:
- First of all, 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 (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
- How to Make All Cells the Same Size in Excel (5 Quick Ways)
- Make Excel Cells Expand to Fit Text Automatically (5 Methods)
- How to Make a Cell Bigger in Excel (Easiest 7 Ways)
- Fix Cell Size in Excel (11 Quick Ways)
- How to Increase Cell Size in Excel (7 Methods)
- [Fixed] AutoFit Row Height Not Working for Merged Cells in Excel
- How to Make Cells Independent in Excel (5 Methods)
