How to make columns and rows in Excel the same size

Sometimes you have worked in a file for so long that you have made multiple changes to your Excel sheets column and row sizes.

Often your sheets looks very messy if columns or rows aren’t the same size.

Make columns the same size

To make columns in Excel the same size simply do the following:

1) Select the column headers you want to make the same size.
2) Now select the border of one of the selected columns and drag it.
3) Release the mouse button and now all your selected columns have the same size.

Select and drag multiple columns to resize them proportionally
Select and drag multiple columns to resize them proportionally
Now both columns have the same width
Now both columns have the same width

Make rows the same size

  1. Select your the row numbers of the rows you want.
  2. Click the border of one row that is selected and drag your mouse.
  3. Release the mouse button and your rows are the same size now.
Select the rows you want to make the same size
Select the rows you want to make the same size
Select the border of one row and drag it
Select the border of one row and drag it
All rows are now the same height
All rows are now the same height

Let me know in the comments if you have any questions!

  • sai

    thanks really good…job