Prantick Bala
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.
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.
- Next, insert the number you wanted as row height and click on OK.
- Consequently, the row height will be adjusted.
- Now go to Home>> Cells>> Format>>Column Width.
- After that, insert the same number as the row height as your column width and click on OK.
- As a result, you will get all the cells with the same row height and column 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.
- After that, enter the desired row height and clcik on OK.
- As a result, the row height will be fixed.
- Now, go to Home>> Cells>>Format>>Column Width.
- Next, set the column width same as the row height in the prompt and press OK.
- As a result, the row and column height and width respectively will be the same for that particular range of cells.
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.
- 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.
- Thereafter, right-click on the column header you want to change width.
- Here, we will choose the B column.
- Next, enter the number you wanted as column width and click on OK.
- Similarly, you can change all the columns’ widths.
- Finally, we will have a dataset which has the same cell height and width.
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.
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.
