How to Make Excel Cells the Same Height and Width

Today, we are going to show how to make cells with the same height and width in Excel. We often find cells with different heights and widths . You may need to make the cells of the same height and width. This makes your dataset more organized and gives it an aesthetic look. It also allows users to manage their data more efficiently.


Download Practice Workbook


4 Ways to Make Excel Cells with 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, we have a dataset of customers, their location, the products that will be delivered to the customers, product price,  and the delivery man who will deliver the package. We can see that 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.

How to Make Cells with Same Height and Width in Excel


1. Making All Cells with Same Height and Width

In this method, we will make the entire sheet cell height and width the same. We will select the entire sheet and then format the cells accordingly.

Steps:

  • First, select all the cells by clicking on the arrow in the upper left corner of your Excel sheet to select the entire sheet.
  • Then, go to Home >> Cells>> Format>>Row Height.
  • As a result, a prompt will be on the screen.

Choosing Row Height Option

  • Next, insert the number you wanted as row height and click on OK.
  • Consequently, the row height will be adjusted.

Selecting Row Height

  • Now go to Home>> Cells>> Format>>Column Width.

Selecting Column Width Option

  • After that, insert the same number as the row height as your column width and click on OK.

Assigning Column Width

  • As a result, you will get all the cells with the same row height and column width.

Making Alll Cells with the Same Hieght and Width


2. Making Selected Cells with Same Height and Width

In this instance, we will choose a particular cell range and make the cell height and width of the cells the same.

Steps:

  • To begin with, select the cells in which you wanted to change height and width.
  • Here, we will choose the B2:F8 range.
  • Then go to Home>>Cells>> Format>>Row Height.
  • Consequently, a prompt will appear on the screen.

Choosing Row Height Command

  • After that, enter the desired row height and clcik on OK.
  • As a result, the row height will be fixed.

Setting Rwo Height to Make Cells with Same Height and Width in Excel

  • Now, go to Home>> Cells>>Format>>Column Width.

Selecting Column Width Opton

  • Next, set the column width same as the row height in the prompt and press OK.

Assigning Column Width to Make Cells with Same Height and Width in Excel

  • As a result, the row and column height and width respectively will be the same for that particular range of cells.

Making Selected Cells with Same Height and Width


3. Using Mouse Options

You can also change column height and row height by using your mouse.

Steps:

  • To change a row’s height, right-click on the row header on the left side of the Excel.
  • In this case, we will select the 2 row.
  • Then, from the available options, choose Row Height.
  • As a result, we will see a prompt on the screen.

Right Clicking on a Row to Choose the Row Height Option

  • After that, write the number you wanted as row height and click on OK in the prompt.
  • In a similar manner, you can change all the rows’ height.

Fixing Row Height to Make Cells with Same Height and Width in Excel

  • Thereafter, right-click on the column header you want to change width.
  • Here, we will choose the column.

Right Clicking on a Column to Choose the Column Width Option

  • Next, enter the number you wanted as column width and click on OK.
  • Similarly, you can change all the columns’ widths.

Assigning Column Width

  • Finally, we will have a dataset which has the same cell height and width.

Using Mouse Options


4. Changing Height and width of Cells by dragging

In this final method, we will simply drag a column or a row to change their width and height respectively. We can also make adjustments to make their height and width the same.

Steps:

  • Firstly, put the cursor at the top or bottom end of any row header.
  • In this case, we will go for row 2.
  • As a result a plus sign will be shown.
  • Then, You can change the height of the row simply by clicking and dragging.
  • Again, put the cursor at the left or right end of the B column header.
  • Then, drag the column by using the plus sign to make the width the same as the row height.

Dragging Rows and Coluumns to Change their Height and Width


Conclusion

In this article, we have talked about how to make cells with the same height and width in Excel. By any of the described methods, you can make Excel cells with the same height and width. If you have any questions regarding this essay, feel free to let us know in the comments. Also, if you want to see more Excel content like this, please visit our website Exceldemy.Com and unlock a great resource for Excel-related content.


Further Readings

Prantick Bala

Prantick Bala

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

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo