How to Make Cells Independent in Excel (5 Methods)

Resizing the cells in Excel to make them independent from other cells is an essential thing to do when it comes to putting a larger word or number in a cell. I’m going to show 5 methods of how to make the cells independent in Excel from others in this article.

I have the following dataset to explain these methods. The figure shows brief information of some persons in a charity organization- their ages, contributions per month, along with Members’ Name and ID numbers.

how to make cells independent in excel


Download Practice Workbook


5 Ways to Make Cells Independent in Excel

1. Adjusting Column Width to Make Cell Size Independent

By adjusting column width you can make the cells independent in Excel. This process can be done in two ways for larger words or numbers.


1.1. Using Double Click to Adjust

If we need to write a word like a person’s name, the characters in that name don’t Fit in a cell most of the time. Watch the figure below. I want to type the first name which is Bryan Danielson but it overflows the cell B5. And this problem may occur for other names too.

  • To solve this problem, first press ENTER after typing Bryan Danielson. Insert other names one by one.

how to make cells independent in excel

You can see that some of the names don’t Fit in the cells (I didn’t put the other entries for convenience).

  • Now put your cursor on the marked area of the following figure.

  • An icon will appear. Now double click on it to complete this operation which will Fit the cells automatically.

how to make cells independent in excel using double click

Thus, you can make the cells of column B independent from other cells.


1.2. Using AutoFit Command From Format

You can do this by using the AutoFit command from the Format option of ribbon too.

  • Type the names of members in cells B5 to B12. You will see that these cells cannot contain the names completely in themselves.

  • Now select cells B5 to B12. Go to Home >> Format >> AutoFit Column Width. 

how to make cells independent in excel by AutoFit Column Width

This operation will Fit the names in their cells make them independent from others.

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


2. Adjusting Row Height to Make Cell Size Independent in Excel

Now, we are going to discuss adjusting row height. We can do this in two different ways too. Let’s go to the procedure.


2.1. Using Double Click to Adjust

  • Type Members’ Name in cell B4. Press ALT + ENTER before typing Name. I did not enter other data for convenience.

how to make cells independent in excel

  • Now press ENTER.

You see that the heading Members’ Name is not clear in cell B4. The same thing will happen when you type Contributions (USD) in cell D4.

how to make cells independent in excel

  • Now, put your cursor on the icon.

  • Double click on it and then you will see that the headings independently Fit perfectly in cells B4 and D4.

how to make cells independent in excel


2.2. Using AutoFit Command From Format

  • Type Members’ Name in cell B4. Press ALT + ENTER before typing Name. I did not enter other data for convenience.

  • Now press ENTER.

how to make cells independent in excel

You see that the heading Members’ Name is not clear in cell B4. The same thing will happen when you type Contributions (USD) in cell D4.

  • Now select any of the cells of the 4th row and then select Home >>  Format >> AutoFit Row Height.

how to make cells independent in excel

This operation will Fit the 4th row clearly and thus it will make the cell size independent from others.

Read More: [Fixed] AutoFit Row Height Not Working for Merged Cells in Excel


3. Make Cells Independent by Using Column Width

We can also define the cell size in 2 different ways to make cells independent from others.


3.1. Dragging Mouse to Set a Point

Suppose you get the following figure after putting the entries in column B in a new Excel Sheet.

how to make cells independent in excel

  • Now put your cursor in the marked area of the following figure.

  • Now drag it to the right until the heading and name Fit in cells. In this case, we dragged to the point where the column width becomes 14.29 units (marked in the following figure).

how to make cells independent in excel

  • After that, you will see the names perfectly Fitted in the cells independently.

Thus, we can make the cell sizes in column B independent from others.


3.2. Using Column Width from Format

We also can do this operation from the Format option of ribbon.

Suppose you get the following figure after putting the entries in column B.

how to make cells independent in excel

  • Select cells from B4 to B12. Then select Home >> Format >> Column Width.

how to make cells independent in excel

You will see a dialog box on the screen. Type 14.3 or any other column width unit you want to put.

how to make cells independent in excel

  • Now click OK.

By following this method, you can define column width on your own to make the cell sizes independent from the other cells.

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


Similar Readings:


4. Defining Row Height to Make Cells Independent

This method is almost similar to the 3rd method. We are going to change row height instead of column width this time.


4.1. Dragging Mouse to Set a Point

how to make cells independent in excel

  • Press ENTER. You cannot see this heading clearly in the cell. The same thing will happen if you type Contributions (USD).

  • Now put your cursor on the icon of the following figure.

how to make cells independent in excel

  • Now drag it down until these headings Fit in cells B4 and D4. In this case, we dragged until the row height became 36 units (marked in the figure).


Now you will see that the cells can contain the headings clearly and they become independent from other cells.

how to make cells independent in excel


4.2. Using Row Height from Format

We also can do this operation from Format ribbon.

  • Type Members’ Name in cell B4.

  • Now press ENTER. You cannot see this heading clearly in the cell. The same thing will happen if you type Contributions (USD) like in section 2.1.

how to make cells independent in excel

  • Select any of the cells in the 4th row. Then select Format >> Row Height.

  • Type 36 in the dialog box and click OK.

how to make cells independent in excel

  • Now you will see the headings perfectly Fitted in cells B4 and D4.

By following this method, you can define column width on your own to make the cell sizes independent from the other cells.

Read More: How to Make Excel Cells With The Same Height and Width (5 ways)


5. Merging Cells for Making the Cells Independent in Excel

Suppose you want to put a main heading on this chart. You want to type Members’ Information in the marked area. We can do this using Merge & Center from Alignment ribbon.

how to make cells independent in excel

  • Select cell B4 and type Members’ Information
  • Now press ENTER.

how to make cells independent in excel

  • Now select cells B4 to E4.
  • Then select Home >> Merge & Center

how to make cells independent in excel

You will see that those 4 cells (B4 to E4) have turned into one cell. Thus it becomes independent from other cells. You can make the text bold and format it in your own way. You also can merge both cells from rows and columns at a time.

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


Practice Section

I have given the dataset in this section so you can practice on your own using the methods I described in this article.


Conclusion

It’s very easy to make the cell size independent from the other cells in an Excel sheet. There may be other methods to do it but I tried to describe easier ones. Hope you will be benefited from this article. If you have any feedback or questions or ideas, feel free to leave them in the comment box.


Related Articles

Nahian

Nahian

Hello, Nahian here! I do enjoy my efforts to help you understand some little basics on Microsoft Excel I've completed my graduation in Electrical & Electronic Engineering from BUET and I want to be a successful engineer in my life through intellect and hard-work, and that is the goal of my career.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo