How to Set the Same Height and Width in Excel Cells

Method 1 – Making Excel Cells Equal by Pixels to Get the Same Height and Width

This is the sample dataset.

Initial Sheets to make Excel Cells Equal by Pixels to Get the Same Height and Width

Click on the image for better quality

Set all columns the same width in the worksheet.

Step 1:

Click Select All => Home tab => Cells.
Click Format => Column Width.

Step 2:

Enter the value.

In the Column Width dialog box, Insert the desired value in Column Width field

Step 3:

Click OK.

This is the output. The width of all columns is 10.

Hitting OK in the Column Width dialog box to equalize all the cell widths within the sheet

Click on the image for better quality

To set all rows the same height.

Step 4:

Hover your mouse over the right side of column A => Click and hold => You will find the Pixel value of the column, 97 pixels.

Step 5:

Place the Cursor below Row 1 and drag it down => Keep track of the Pixel value => Release the Cursor when the Pixel value is 97 =>

You will see the cells within the sheet with the same height and width.

Note

We must set cells equal by Pixels. Making equal points is unable to create the same height and width.

Method 2 – Using the Scale Feature in Page Layout View to Make Cells the Same Height and Width

This is the worksheet.

Initial Sheets to make Excel Cells Equal in Height and Width using Page Layout Feature

Step 1:

Click Select All => Go to the View tab => In View, select Page Layout.

Note

The Page Layout view command is also available at the bottom-right corner of your workbook.

An alternative area to find the Page Layout view is the bottom-right corner of your workbook

Step 2:

You will see measuring scales above the columns and on the left side of the rows.

Click on the image for better quality

Step 3:

Go to the Home tab=> click Format in Cells.

Go to Home, expand the Format drop down and choose Column Width

Click on the image for better quality

Step 4:

Click Column Width.
Enter 1.

Input 1 inch in the Column Width field

Step 5:

Click OK.

Cells width become 1 inch.

All the cell column widths become 1 inch

Step 6:

Click Format and choose Row Height.

Step 7:

Enter 1.

Input 1 inch in the Row Height field

Step 8:

Click OK to see the output.

Using Page Layout Feature to Make Cells Same Height and Width

Read More: How to AutoFit in Excel

Method 3 – Using an Excel VBA Code to set Cells with Equal Height and Width

3.1 Same Height and Width Cells for the Entire Worksheet

Initial Excel Sheet to make Cells Equal in Height and Width within Entire Worksheet using VBA

Step 1:

Go to the Developer tab =>Select Visual Basic in Code.

Navigate to Developer and choose Visual Basic

Step 2:

Select Insert and click Module => Enter the following code in the module => Run.

Sub MakeCellsEqualHeightWidth()
   
    With Cells(1, 1)
        Cells.RowHeight = .Width
        Cells.ColumnWidth = .ColumnWidth
    End With

End Sub

Insert the intended code to make Same Height and Width Cells for Entire Worksheet

Note

You can also open the VBA Editor window by pressing Alt+F11.

Step 3:

Go back to the sheet and see the result.

Output of running VBA to make same height and width cells for Entire Worksheet

3.2 Same Height and Width for Selected Cells

Consider A4:D7.

Initial Sheet to make Excel Cells Equal in Height and width for selected cells using VBA

Step 1:

Select A4:D7 => Go to the Developer tab => Select Visual Basic.

Select the mentioned range, go Developer and choose visual basic

Step 2:

Select Insert >> click Module => Enter the code below in the module => Run.

Sub EqualizeSelectedRange()

    Dim max_width
    max_width = 0

    Dim selectedRange As Range
    Set selectedRange = Selection

    For Each cell In selectedRange
        If cell.Width > max_width Then
            max_width = cell.Width
        End If
    Next cell

    If max_width > 0 Then

        aspect_ratio = max_width / selectedRange.Cells(1, 1).EntireColumn.ColumnWidth

        For Each cell In selectedRange
            cell.EntireColumn.ColumnWidth = max_width / aspect_ratio
            cell.RowHeight = max_width
        Next cell
    End If

End Sub

Insert the intended code to make Same Height and Width Cells for Selected Cells

Step 3:

Go back to the sheet and see the result.

Output of running VBA to make same height and width cells for Selected Cells

Note

3.3 Same Height and Width for a Used Range

Consider the Used Range A4:D7.

Initial Excel Sheet to make Cells Equal in Height and Width within Used Range using VBA

Step 1:

Go to Developer >> Select Visual Basic.

Go to Developer and choose Visual Basic to open VBA editor

Step 2:

Select Insert >> click Module >> Enter the following code in the module >> Run.

Sub equalizeUsedRange()

    Dim max_width
    max_width = 0

    Set ws = ThisWorkbook.ActiveSheet

    For Each cell In ws.UsedRange
        If cell.Width > max_width Then
            max_width = cell.Width
        End If
    Next cell

    aspect_ratio = max_width / ws.Cells(1, 1).EntireColumn.ColumnWidth

    For Each cell In ws.UsedRange
        cell.EntireColumn.ColumnWidth = max_width / aspect_ratio
        cell.RowHeight = max_width
    Next cell

End Sub

Insert the intended code to make Same Height and Width Cells for Used Range