In this article, we will get to know several methods of how to increase Cell size in MS Excel. When we create a new Excel workbook, the Row Height and Column Width are set to a certain point for all Cells by default. However, sometimes we need to increase single, multiple, or all Cell sizes & it can readily be changed by increasing one or more Rows and Columns in Height and Width respectively following several methods.
Suppose we want to keep a trace of the Office ID & Present Address of 5 employees using Excel. When we create a new worksheet it has Column Widths & Row heights set by default. After introducing our dataset into excel from the image below, we can find that Cell sizes aren’t enough to Fit our dataset. If that’s the case we have to increase Cell sizes by adjusting Column Widths & Row heights. Now we will learn How to Increase Cell Size for the following dataset.
Download Practice Workbook
Method 1. Use the Format from Ribbon to Increase Cell Size with Specific Measurement
In this method, we will learn how to increase Cell Heights or Row Widths using the Format ribbon when we want to have Cells with specific measurements.
- First, we have to select the Cells or Columns or Rows that we want to adjust.
- In case we want to adjust all Cells we need to press the upper corner to select All first.
- In the above dataset, we need to increase Column B, C & D & also the Rows.
- Now select the Home tab first.
- Then from the Cells group select Format.
- To change Row Heights select Row Height from the Format.
- Say we want Row Heights to be 20. Then type 20 in the Row height box & press OK.
- To change Column Widths we have to follow the Home tab >> Cells >> Format >> Column Width.
- Suppose we want to increase cell size by increasing Column Widths to 22. Then type 22 in the Column Width box & press OK.
- Now the final dataset will look ordered like this.
Read More: How to Change Cell Size in Excel (5 Methods)
Method 2. Using Context Menu to Increase Cell Size with Specific Measurement
Here we will learn how to adjust Cell Widths or Row Heights using the Context Menu when we want to have Cells with fixed measurements.
2.1. Use Context Menu to Adjust Row Heights to Specific Measurement
Here I am going to change Row Heights using Context Menu.
- First, we have to select the Row Headings that we want to change.
- Here we want to Increase the size of Row 1-9.
- Then clicking left on any of the cells the Context Menu will appear.
- Now from the Context Menu, we will select the Row Height.
- Say we want Row Heights to be 20. Upon typing 20 in the Row Height box and pressing OK.
- Now All the selected Row Heights will turn 20.
2.2. Use Context Menu to Increase Column Widths to Specific Measurement
Here I am going to show you how to increase Row Heights using Context Menu.
- First, we have to select the Column Headings that we want to Increase.
- Here we want to increase Columns B & D.
- To select both non-consecutive columns we have to press CTRL in between selecting Column B & D.
- Then clicking on any of the Cells from the selected region, Context Menu will appear.
- Now from the Context Menu, we will select the Column Width box.
- If we want Column B & D to be 22, then we have to type 22 in the Column Width box & then press OK.
- Now the dataset after following Sub Method 2.1 & 2.2 will look like the image below having Increased Cell size.
Read More: How to Change Cell Size without Changing Whole Column (2 Methods)
Method 3. Using Mouse to Increase Cell Size
In this method, we will see how to Increase the Cell size using Mouse.
- Initially, we have to select the cell or cells that we want to Increase in size.
- Here we want to change the Width of Cell C4 & to do that we have to Increase the Width of Column C.
- To do so, first, we move the Cursor in between Column C & D.
- When it turns into Double Arrow we have Right click on Mouse & move the boundary towards Column D until the size is increased enough to Fit the values.
- Moving the Cursor up to the desired distance we will drop the Mouse & get the new width of Column C.
- We can apply the above two steps to Increase the Height of the Row & other Columns Widths to get the final result below.
Read More: How to Make All Cells the Same Size in Excel (5 Quick Ways)
- How to Make Cells Independent in Excel (5 Methods)
- [Fixed] AutoFit Row Height Not Working for Merged Cells in Excel
- How to Fix Cell Size in Excel (11 Quick Ways)
Method 4. Applying AutoFit Feature From Format Ribbon
Here we will learn how to Increase the Cell size using the AutoFit feature of MS Excel.
- In the beginning, we have to select the Cell, or Column, or Row that we want to AutoFit.
- Here we have selected Column B to Autofit.
- Upon selecting B4 follow Home tab >> Cell >> Format >> Autofit Column Width.
- After clicking AutoFit Column Width, Column B will be adjusted automatically while increasing cell size to Fit the data.
- The same can be done for Column C & D & also for desired Rows.
Method 5. Using Mouse to AutoFit Cells
- Suppose we want to AutoFit Row 4 using Mouse.
- First, move to Cursor to the border line of Row 4 & 5 to let the Double Arrow sign appear.
- After the Double Arrow sign appears, Left click the Mouse Twice to AutoFit Row 4.
- Here, the size of the cell is increased to Fit the values of the row.
Read More: How to Autofit in Excel (7 Easy Ways)
Method 6. Employing Keyboard Shortcut to Increase Cell Size
Here we will learn how to use keyboard Shortcuts to Increase Cell size.
6.1. Using Keyboard Shortcut to Increase Column & Row Size
We can increase the size of a Cell, Row, or Column using Keyboard shortcuts. Here we will learn the procedures.
- Initially, we have to select the Cell or Row or Column. Here we have selected Column B.
- Then upon pressing Alt + H & then O the Format ribbon will open.
- Then to change Row Height we have to press H or to change Column Width we have to press W.
- Say we have pressed W to open the Column Width dialog box.
- Now we will have to type the measurement in the Column Width box & then press OK. Here I have selected 20 to be the Column Width.
- Finally, we will have the desired dataset.
6.2. Using Keyboard Shortcut to AutoFit
In this section I’m going to show you how to AutoFit using Keyboard Shortcut in order to Increase the Cell size.
- We can also AutoFit Columns or Rows using Keyboard shortcuts.
- To AutoFit column width: Follow Alt + H >> O >> I.
- To AutoFit row height: Follow Alt + H >> O >> A.
- Here we have AutoFit Column Width pressing I & got the result below.
- Please note that you should not press all of the keys at once. Rather, each key/key combination should be pressed and released separately.
Read More: How to Use AutoFit Shortcut in Excel (3 Methods)
Method 7. Merge Cells to Adjust Cell Size
Now we will learn that Merging several cells is one technique to Increase the size of a Cell in Excel without affecting the entire Row or Column. Merging Cells combines two or more cells into a single cell that spans multiple rows or columns.
- First, select the cells that you want to Merge. While Merging, remember that Cells only take the value of the Upper Left Cell after being Merged.
- Here we want to Merge cells D4 & E4. Let’s select those cells.
- Then click Home tab >> Merge & Center.
- Following Cells will be Merged now & a bigger Cell appeared comprising both D4 & E4 Cells without affecting other Cells of Column D & E or Row 4.
- We can repeat this process to Merge Cells D5 & E5 too.
- Repeating the procedures for Row 6,7,8 & 9 of Columns D & E we will get the desired outcome.
Read More: How to Reset Cell Size to Default in Excel (5 Easy Ways)
I’ve provided a practice sheet to practice these applied methods by yourself.
Reading the article above, we have already learned How to Increase Cell Size in Excel. So, using the above methods we can easily adjust size or single or multiple Cells, Rows or Columns. Increasing Cell size often makes our dataset easy to read, convenient & beautiful. If you have any confusion regarding Increasing Cell size, please leave a comment. See you next time!
Excellent tutorial and really helpful
Thanks for your feedback, Azam!
Excellent & very easy piece of writing. Found it very helpful.
thanks man! It literarily saved me today. I started loving excel.