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

Cells with different heights and widths make your Excel sheet disorganized. You may feel the need to make the cells with the same height and width. In this article, you will find five ways with which you will be able to make Excel cells with the same height and width.

Look at the following dataset. Here the cells have different heights and widths which doesn’t look good. Now we will make the cells of this dataset with the same height and width.

Excel cells with same height and width

Download Practice Workbook

5 Ways to Make Excel Cells With The Same Height and Width

1. Making All Excel Cells with Same Height and Width

First, select all the cells by clicking on the arrow in the Left upper corner of your Excel sheet.

Excel cells with same height and width

Then go to Home> Cells> Format>Row Height

Excel cells with same height and width

Insert the number you wanted as row height and click on OK.

Excel cells with same height and width

Now go to Home> Cells> Format>Column Width

Excel cells with same height and width

Insert the number you wanted as column width and click on OK.

Excel cells with same height and width

You will get all the cells with the same row height and column width.

Excel cells with same height and width

2. Making Selected Excel Cells with Same Height and Width

Select the cells in which you wanted to change height and width.

Excel cells with same height and width

Then go to Home> Cells> Format>Row Height

Excel cells with same height and width

Insert the number you wanted as row height and click on OK.

Row Height

Now go to Home> Cells> Format>Column Width

Column Width

Insert the number you wanted as column width and click on OK.

Column width

You will get your selected cells with the same row height and column width.

Same height and width

3. Making same Height and Width of Cells Using Mouse

You can also change column height and row height by using your mouse. Right-click on the column header you want to change width and select Column Width.

Excel cells with same height and width

Insert the number you wanted as column width and click on OK.

column width

In a similar manner, you can change all the columns’ widths.

column width

To change a row’s height, right-click on the row header on the left side of the Excel and select Row Height.

row height

Insert the number you wanted as row height and click on OK.

Excel cells with same height and width

In a similar manner, you can change all the rows’ height.

row height


4. Changing Height and width of Cells by dragging

If you put the cursor at the left or right end of any column header, a plus sign will be shown. You can change the width of the column simply by clicking and dragging.

Excel cells with same height and width

If you put the cursor at the top or bottom end of any row header, a plus sign will be shown. You can change the height of the row simply by clicking and dragging.

Excel cells with same height and width

5.   Making Selected Cells to AutoFit The Content

You can change the column width and row height as a manner that will automatically fit the content. First, select the cells to which you want to change the column width and row height to automatically fit the content. For auto fitting column width, go to Home> Cells>Format> click AutoFit Column Width.

auto fit

For auto fitting row height, go to Home> Cells>Format> click AutoFit Row Height.

Auto fit

Column Width and Row height of all the cells will be changed to autofit the contents in the cells.

auto fit

Conclusion

By any of the described methods, you can make Excel cells with the same height and width. If you have any confusion regarding any of the methods, please leave a comment, I’ll try my best to solve the confusion. You can also see for-


Further Readings

Prantick

Prantick

Hi, I'm Prantick Bala, currently working and doing research on Microsoft Excel in Softeko.com. I have completed BSc in Naval Architecture and Marine Engineering From Bangladesh University of Engineering and Technology (BUET). Currently I am in the last semester of my MBA at Institute of Business Administration (IBA), Dhaka University (DU). I'm always eager to learn through experience and have a deep interest in solving problem to get optimum solution.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo