Do you want to find out how to make rows the same size in Microsoft Excel? You’ve come to the right place. Keep reading!

When you open an Excel file with inconsistent row heights, you might immediately feel off. Uneven rows make your spreadsheet harder to read, break visual flow, and can even distract from the actual data.

Whether you’re preparing a report, managing schedules, or just organizing information, keeping your rows the same size is key to maintaining a clean, professional layout. It improves readability, enhances presentation, and helps you stay focused on the task, not on messy formatting.

But getting those row sizes right can be tricky if you don’t know where to look. In this guide, I’ll show you exactly how to do it, following various popular methods.

Using the Row Height Tool to Set a Default Size

One reliable way to make all rows the same size in Microsoft Excel is by using the Row Height tool to set a default row height in your workbook template. This method ensures that every new sheet or table you work on starts with a consistent row size. It saves you from fixing formatting over and over again.

Using this method in a template gives you a huge advantage. It eliminates distractions caused by mismatched row sizes and helps maintain a clean, professional structure throughout your workbook. You won’t need to repeatedly resize rows in every new file you create from that template. This is especially helpful for you if you’re an office user or a data analyst who wants to focus on content, not formatting.

Let me walk you through the workflow of this method in simple steps below:

Open a blank Excel workbook that you want to use as a template. Avoid typing any content for now so you can focus purely on formatting the structure.

Select all rows in the worksheet by clicking the Select All triangle button at the top-left corner, where the row numbers and column letters meet. This ensures every row available now or might be created in the future is included.

Go to the Cells commands block in the Home tab and click on the Format drop-down command.

Select Row Height from the context menu that shows up.

In the Row Height dialog box that appears, type the height value you want for all rows. Fr example, enter 20 and then click OK. The worksheet will instantly update to apply this uniform row height.

Now, go to the File tab on the ribbon and select Save As. Choose your save location and under Save as type, pick Excel Template (*.xltx).

Give your template a name you’ll remember, like Uniform Row Height 20 Px, and save it. Excel will store it in your default templates folder for easy access later.

Once you’re done creating the template file, here’s how you can use it:

Open Microsoft Excel from your Start menu or desktop shortcut. Wait for the Home screen to load, where recent files and options appear.

On the Home screen, click More Templates or Personal (depending on your Excel version). This will show templates you’ve saved on your device.

Look for your custom template by name, for example, Uniform Row Height 20 Px. Click on it once you find it.

Excel will open a new workbook based on that template. This new file will inherit the row height and any other formatting you saved.

Using the Right-Click Context Menu

One of the fastest ways to make rows the same size in Microsoft Excel is by using the right-click context menu. This method is straightforward and doesn’t require digging through tabs or menus. You just select the rows you want, right-click, and set the row height right there.

What makes this method especially useful is its speed and simplicity. You don’t have to prepare a template or apply anything workbook-wide. If you’re adjusting a few rows in a report, budget sheet, or timesheet, this gives you the fix in seconds. It’s ideal when you’re in a rush, working on a one-off file, and just want the rows to line up neatly without overthinking it.

Find below the quick steps to practise this method:

Click and drag your mouse across the row numbers on the left-hand side of Excel to select the rows you want to resize. Make sure you’re only selecting the rows where you want the same height applied.

Right-click on the selected rows.

In that context menu, click the option labeled Row Height. This will open a small dialog box in the middle of your screen.

In the Row Height dialog box, type the number that represents the height you want for all selected rows, for example, 20, and then click OK.

Excel will immediately adjust all the selected rows to that exact height.

If you’re not sure what number to use, try a few different values until the content fits well and looks balanced. You can repeat this process anytime you need to tweak the layout on the fly.

Once done, take a quick scroll through your worksheet to make sure everything looks aligned. If not, just use the Excel undo feature with Ctrl + Z and try a different height.

Copy Row Height Using the Format Painter Tool

One surprisingly effective way to make rows the same size in Microsoft Excel is by using the Format Painter tool to copy the row height from one row to others. This tool is typically known for copying formatting like font styles or cell colors, but it also transfers row height.

If you’ve already adjusted one row to look just right, you can apply that exact same look, including height, to others in just a couple of clicks. It’s fast, visual, and doesn’t require typing any numbers or opening any menus.

This method is perfect when you’re in the middle of editing and just need a few rows to match. It’s not something you set up in advance, like a template, but it gives you instant visual consistency.

Let’s use the simple steps outlined below to practise this method:

First, adjust one row manually by dragging its bottom edge until it looks the way you want. This row will serve as your Format Source for the others.

Click the row number of that adjusted row to select the whole row. Make sure only that one row is selected.

Go to the Home tab in the ribbon at the top of Excel. In the Clipboard group, click on the Format Painter button once (don’t double-click).

Now, move your mouse to the row number you want to match in size and formatting. Click on the row number. This will apply the copied row height and formatting instantly.

If you want to apply the same height to multiple rows, double-click the Format Painter button instead of single-clicking it. Then click each target row one by one until you’re done.

Now, press Esc to exit Format Painter mode.

This method also copies cell formatting like borders and fonts, so it’s best used when that kind of consistency is needed too. Check your updated rows to make sure everything looks uniform.

Using the Paste Special Tool

One practical way to make rows the same size in Microsoft Excel is by using the Paste Special tool. This method works by copying the formatting, including row height, from one row and applying it to others. It doesn’t just copy fonts or colors; it also includes layout details like size. If you’ve set one row just the way you like it, this tool helps you quickly mirror that across other rows without adjusting anything manually.

Here are the steps you can try out:

Start by selecting the entire row that already has the desired height and formatting. You can do this by clicking on the row number on the left side of the worksheet.

Once selected, press Ctrl + C on your keyboard to copy that row. Alternatively, right-click on the selected row and choose Copy from the context menu.

Next, select the target rows you want to apply the same height to by clicking and dragging over their row numbers. Be careful not to select any cell content, just the row numbers on the side.

Right-click on the selection and choose Paste Special from the context menu. In the dialog box that appears, click on the Formatting option below the Other Paste Options section and then click OK.

Excel will now apply the copied row’s formatting, including its height, to all selected rows. You’ll see the change immediately without altering your data.

This method is great when you’re already working with existing content and want to clean things up without extra setup.

Using an Excel VBA Macro

If you need to apply different row sizes in different worksheets frequently, you can follow the Excel VBA-based approach. Here, with the help of a VBA script, you can make the row sizes the same automatically with a single click. The entire process is visual since multiple dialog boxes will walk you through.

Before you can begin, learn how to create a VBA macro from a VBA script in Excel by going through this quick guide:

When you’re ready, use the following VBA script to create a macro on the active workbook:

Sub SetUniformRowHeightWithPrompt()
    Dim rowHeight As Variant
    Dim userRange As Range
    Dim ws As Worksheet

    ' Ask user for preferred row height
    rowHeight = InputBox("Enter the preferred row height (e.g., 20):", "Set Row Height")

    ' Validate input
    If Not IsNumeric(rowHeight) Or rowHeight = "" Then
        MsgBox "Invalid input. Please enter a numeric value.", vbExclamation, "Invalid Height"
        Exit Sub
    End If

    ' Prompt user to select rows
    On Error Resume Next
    Set userRange = Application.InputBox("Select the target rows using your mouse:", "Select Rows", Type:=8)
    On Error GoTo 0

    ' Exit if user cancels or doesn't select a range
    If userRange Is Nothing Then
        MsgBox "No rows selected. Operation cancelled.", vbInformation, "Cancelled"
        Exit Sub
    End If

    ' Apply the row height
    userRange.EntireRow.RowHeight = CDbl(rowHeight)

    ' Confirmation message
    MsgBox "Row height set to " & rowHeight & " for selected rows.", vbInformation, "Success"
End Sub

Did you create the macro? Perfect! Press Alt + F8 to launch the Macro dialog box.

Here, select the SetUniformRowHeightWithPrompt macro and click on the Run button.

The Excel VBA macro will ask you to enter the desired row height in a dialog box.

Then, it’ll also ask you to select the target cell range on the active worksheet.

When you respond to both dialog boxes appropriately, the macro will resize the selected rows to the same size.

Conclusions

There are several ways to make rows the same size in Excel, and each works best in different situations.

From the Row Height tool and Right-Click menu to Format Painter, Paste Special, and even VBA, you can pick a method based on how quick or advanced you need it to be.

Tried one of these or have your own go-to method? Share it in the comments!