# How to Change Cell Size without Changing Whole Column (2 Methods)

Get FREE Advanced Excel Exercises with Solutions!

Excel is one of the most useful tools when it comes to dealing with a huge dataset. Often, we need to change the cell size without changing the whole column in Excel. In this article, I will explain 2 efficient ways to do so.

This is the worksheet I am going to use to explain the methods. We have several students along with their Student ID and their Marks. I am going to change the cell size containing the heading (that is, B2).

## 2 Ways to Change Cell Size without Changing Whole Column

### 1. Applying Merge & Center to Change Cell Size without Changing Whole Column

Before illustrating the method, let me first explain what we are up to. In the dataset, you will see that I have Change Cell Size in cell B2. But the text Change Cell Size has exceeded the border of B2.

Now, if you solve this problem by increasing the column size, Excel will change the size of the entire column. This will make your dataset unappealing.

To deal with this issue, you can use Merge & Center.

STEPS:

➤ Select the range B2:D2. Then go to the Home tab >> select Merge & Center

Excel will merge B2:D2.

### 2. Using Keyboard Shortcut to Change Cell Size without Changing Whole Column

Now, I will explain the keyboard shortcuts `ALT + H``, ``M ``, and ``C ` to apply the Merge & Center.

STEPS:

➤ Select the range B2:D2.

➤ Then press ALT + H. Your datasheet will look like this.

➤ Then press M. Your datasheet will look like this.

Excel will show you the options available in Merge & Center. Choose the one you like. I will choose Merge & Center. So, I will press C.
As a result, Excel will merge B2:D2.

NOTE: If you want to keep the cell size as it is you can unmerge cells from Merge & Centre.

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

## Practice Workbook

So, I hope you all know how to change the cell size without affecting the whole column in Excel. To master this skill, you should practice. That’s why I have added a practice sheet for you.

## Conclusion

In this article, I have illustrated 2 efficient ways to alter the cell size without altering the whole column in Excel. I hope this will benefit you. And lastly, if you have any kind of suggestions, ideas, or feedback please feel free to comment down below.

## Related Articles

#### Akib Bin Rashid

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF