How to Change Cell Size in Excel (5 Methods)

We always change cell size in Excel. There is more than one way to do this task. We have explained 5 methods of how to change cell size in Excel.

To understand the methods more clearly, we have taken a sample dataset containing employee names, their emails, and their respective departments.  The dataset has 3 columns: Name, Email, and Department. We aim to change the cell size in Excel to show the values easily.

Change Cell Size in Excel

Download Practice Workbook


5 Ways to Change Cell Size in Excel

1. Change Cell Size in Excel Using Format Menu

We can’t see the full value of column Name and Email and cell D6. To show that we will be applying the Format option of Excel.


1.1. Using Row Height

Firstly, we will change the row height of our cell D6. Follow the guide below to know about that.

Change Cell Size in Excel

Steps:

  • Select cell D6.
  • From the Home tab >>> go to Format >>> then select Row Height…

Change Cell Size in Excel

A dialog box will appear.

  • Type 35 in the Row height box.
  • Then click OK.

This value can be set by trial and error. If the value is not enough, we need to increase or decrease it.

Change Cell Size in Excel

Cell D6 is visible fully to us.


1.2. Using Column Width

Full-length values from the columns are not visible to us. We will make it clear to see by changing the Column width.

Change Cell Size in Excel

As not all columns are equal in size, we will do this method column by column. You can select all three columns and perform the same steps.

Steps:

  • Select the Name column in the table. range B4:B11.
  • From Home tab >>> Format >>> Column Width…

A dialog box will appear.

  • Type 18 in the Column width.
  • Press OK.

Change Cell Size in Excel

The Name column is fully visible to us.

Similarly, we can do it for Email and Department columns. The values for column width are 26, and 27 respectively.

This is what the final table looks like.

Change Cell Size in Excel

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


2. Using AutoFit to Change Cell Size in Excel

Now, We will use AutoFit to change the cell size in our dataset. Follow along our step by step guide:

Steps:

  • Select the range where you want to apply AutoFit.
  • Here, I selected the range B4:D11.
  • From Home tab >>> Format >>> AutoFit Column Width.

Change Cell Size in Excel

This will AutoFit the columns.

We will AutoFit the rows now.

  • Re-select the table (If it is already selected no need to do it again).
  • Home >>> Format >>> AutoFit Row Height.

Change Cell Size in Excel

Our dataset is good to go.

Read More: How to Use AutoFit Shortcut in Excel (3 Methods)


3. Matching the Column Width to Change Cell Size in Excel

We will be using the match column width command from Paste Special to change cell size in Excel. Our Email column will match the width of the column Department.

Change Cell Size in Excel

Steps:

  • Select the cell range D4:D11.
  • Use CTRL + C to copy the cell.

  • Select the Email column.
  • From the Home tab >>> Paste >>> Paste Special…

Change Cell Size in Excel

  • Select Column widths.
  • Press OK.

The Email column width is matched with the Department column.

Change Cell Size in Excel

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


Similar Readings:


4. Using the Context Menu to Change Cell Size

We can change the cell size in Excel by utilizing the Context menu.

Steps:
In this method, we will change the column width in one go.

  • Select the 3 columns.
  • Right-click on the mouse to bring up the Context Menu.
  • Select Column Width…

Change Cell Size in Excel

A dialog box will appear.

  • Type 22 in the Column width.
  • Press OK.

The cell size in the Excel dataset has changed.

Change Cell Size in Excel

Notice, our cell D6 is not visible yet. To correct that:

  • Select cell D6.
  • Right-click on the mouse to bring up the Context Menu.
  • Click Row Height…

A dialog box will appear.

  • Type 35 in the Row height.
  • OK.

Change Cell Size in Excel

The final table should look like this.

Read More: How to Autofit in Excel (7 Easy Ways)


5. Change Cell Size by Merging Multiple

In our dataset, the column label “Department” is not showing properly. We can merge column D with column E in the table. This way we also can change our cell size.

Change Cell Size in Excel

Steps:

  • Select cell range D4:E4.
  • From Home tab >>> Merge & Center >>> Merge Cells.

The cell range will be merged. Now, we can see the text “Department”.

Change Cell Size in Excel

Similarly, we can perform the same actions on the rest of the cells. Remember, we need to select the cells one by one.

Here is what the final table should look like.

Change Cell Size in Excel


Practice Section

We have included the original datasets in each of the methods in the Excel file. You can practice those to master the methods shown above.

Read More: How to Make All Cells the Same Size in Excel (5 Quick Ways)


Conclusion

We have used 5 methods of how to change cell size in Excel. We have used the Format cell option, AutoFit, matching column width, Context menu, and merging cell to achieve our target. If you face any problem while applying any of the five methods, you can comment here for assistance. Thanks for reading. Keep excelling!


Related Articles

Rafiul Haq

Rafiul Haq

Hello! This is Rafiul. I have an engineering degree and an MBA (finance) degree. I am passionate about all things related to data, and MS Excel is my favorite application. I want to make people's lives easier by writing easy-to-follow and in-depth Excel and finance related guides here at ExcelDemy.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo