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

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.


Download Practice Workbook

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).

How to Change Cell Size Without Changing Whole Column


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.

How to Change Cell Size Without Changing Whole Column

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

How to Change Cell Size Without Changing Whole Column

Excel will merge B2:D2.

How to Change Cell Size Without Changing Whole Column

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


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.

How to Change Cell Size Without Changing Whole Column

➤ 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.

How to Change Cell Size Without Changing Whole Column

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.

How to Change Cell Size Without Changing Whole Column


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

Akib

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

Leave a reply

ExcelDemy
Logo