How to Make All Cells the Same Size in Excel: 5 Easy Methods for Perfectly Aligned Spreadsheets (2026)

Method 1: Set Uniform Column Width Manually

This is the most direct way to make all columns equal in size.

1. Open your Excel worksheet.
2. Select the entire sheet by clicking the triangle at the top left corner or select multiple cells.
3. Go to the Home tab.

4. Click Format menu in the Cells group to change column width.

   5. From drop down menu Select Column Width.

Add image alt text

6. Enter specific width value for excel column such as 15 or 20.
7. Click OK.

All the cells in columns will immediately adjust to the same width.

Add image alt text

Method 2: Set Uniform Row Height Manually

Row height can be standardized in the same way as columns.

1. Select the entire worksheet.
2. Go to the Home tab.
3. Click Format in the Cells group.

4. Select Row Height.

   5. Enter a value such as 20.

Add image alt text

6. Click OK.

All rows will now have identical height.

Add image alt text

Add image alt text

Method 3: Make All Cells the Same Size Using Select All + Drag

This is a fast visual method for quick formatting.

1. Click the Select All button in the top-left corner.

2. Hover over any column boundary in the column heading row.

   3. Drag to set desired column width or double click to autofit column width.

Add image alt text

4. Repeat for row boundaries to adjust height.

All selected cells will adjust uniformly.

Add image alt text

Method 4: Use AutoFit and Then Standardize Size

AutoFit helps normalize content first before applying uniform sizing.

1. Select the entire worksheet.
2. Go to the Home tab.

3. Click Format.

   4. Select AutoFit Column Width.

Add image alt text

5. Repeat autofit Row Height if needed.
6. Then set a fixed column width and row height manually.

Add image alt text

Method 5: Use VBA to Make All Cells Uniform Automatically

For repetitive tasks or large files, VBA provides automation.

1. Press ALT + F11 to open the VBA editor.

2. Click Insert and select Module.

   3. Paste the code below.

Add image alt text

4. Run the macro.

Sub SetUniformCellSize()
    Dim ws As Worksheet
    Set ws = ActiveSheet
    ws.Cells.ColumnWidth = 15
    ws.Cells.RowHeight = 20
End Sub

Sub SetUniformCellSize()
    Dim ws As Worksheet
    Set ws = ActiveSheet
    ws.Cells.ColumnWidth = 15
    ws.Cells.RowHeight = 20
End Sub

Sub SetUniformCellSize()
    Dim ws As Worksheet
    ws = ActiveSheet
    ws.Cells.ColumnWidth = 15
    ws.Cells.RowHeight = 20
End Sub

Common Issues and Troubleshooting

Choosing the Right Method

Different situations require different approaches.

| Scenario | Best Method | | --- | --- | | Quick formatting | Drag method | | Precise uniform layout | Manual width/height | | Imported messy data | AutoFit + standardize | | Large-scale automation | VBA | | Clean report design | Manual + formatting |

For Developers: Standardize Excel Cell Sizes with IronXL

In automated systems, Excel files are often generated dynamically. Ensuring consistent cell sizing manually is not practical in such cases.

IronXL, a .NET library for working with Excel files, lets developers adjust worksheet formatting programmatically, including column widths and row heights.

using IronXL;
WorkBook workbook = WorkBook.Create();
WorkSheet sheet = workbook.CreateWorkSheet("Sheet1");
// Set uniform column width and row height
sheet.Columns[0].Width = 15;
sheet.Columns[1].Width = 15;
sheet.Columns[2].Width = 15;
sheet.Rows[0].Height = 20;
sheet.Rows[1].Height = 20;
sheet.Rows[2].Height = 20;
workbook.SaveAs("UniformCells.xlsx");

using IronXL;
WorkBook workbook = WorkBook.Create();
WorkSheet sheet = workbook.CreateWorkSheet("Sheet1");
// Set uniform column width and row height
sheet.Columns[0].Width = 15;
sheet.Columns[1].Width = 15;
sheet.Columns[2].Width = 15;
sheet.Rows[0].Height = 20;
sheet.Rows[1].Height = 20;
sheet.Rows[2].Height = 20;
workbook.SaveAs("UniformCells.xlsx");

Imports IronXL

Dim workbook As WorkBook = WorkBook.Create()
Dim sheet As WorkSheet = workbook.CreateWorkSheet("Sheet1")
' Set uniform column width and row height
sheet.Columns(0).Width = 15
sheet.Columns(1).Width = 15
sheet.Columns(2).Width = 15
sheet.Rows(0).Height = 20
sheet.Rows(1).Height = 20
sheet.Rows(2).Height = 20
workbook.SaveAs("UniformCells.xlsx")

Installation

Install IronXL via NuGet Package Manager:

Install-Package IronXL.Excel

• Learn how to make all cells the same size in excel using IronXL
• See also how you can group and ungroup column with IronXL

Benefits of Using IronXL for Cell Formatting

• Automates repetitive formatting tasks
• Ensures consistent spreadsheet design
• Works in server-side applications
• Handles large datasets efficiently
• Reduces manual Excel work

Conclusion

Making all cells the same size in Excel is a simple but powerful formatting technique that improves readability, structure, and presentation quality. Whether you are manually adjusting column widths, using AutoFit, or applying VBA automation, each method serves different levels of complexity and use cases.

For developers working with automated reporting systems, IronXL provides a reliable way to standardize Excel layouts programmatically, ensuring consistent formatting without manual effort.

With the right approach, you can transform messy spreadsheets into clean, professional, and easy-to-read reports.