Follow along with the methods below to learn how to make Microsoft Excel columns the same width.

When I look at a spreadsheet with inconsistent column widths, I feel distracted. It’s like a presentation slide with misaligned text boxes. It’s not just about appearance; uneven columns can make data harder to read and interpret.

If you’ve been frustrated by this, you’re not alone. Getting all columns to the same width in Microsoft Excel may seem like a small task, but without the right steps, it can waste time and disrupt your workflow.

In this tutorial, I’ll show you how to quickly fix that. Follow along, and you’ll have clean, consistent columns in no time. Let’s get started.

Using the Default Width Tool

Using the Default Width tool is one of the quickest ways to make columns the same width in Excel. Instead of adjusting each column manually, this tool applies a uniform width to all columns that haven’t been resized individually.

This method is especially helpful when you need a quick fix. Maybe you’re reviewing a report or organizing data for a one-time presentation, and you don’t want to waste time setting up a polished template. In such cases, you must use the Default Width tool. Now, let me walk you through the process below:

Open your Excel workbook and make sure you are on the worksheet where you want to adjust the columns. Take a quick look to confirm which sheet you are working on, especially if multiple sheets are open.

Go to the Home tab on the ribbon and find the Format option in the Cells group. Click it once to display a drop-down list of formatting options.

In the drop-down, choose Default Width. A small dialog box will pop up, ready for you to set a new number.

Type the width you want in the box. Use a whole number or decimal, for example, 6 or 6.5). It depends on how much space your data needs. The unit of column widths in Excel is characters. If you enter 6 in the Standard Width box, the column width will be suitable for up to six characters.

Click OK to apply the change. Every column that hasn’t been manually resized will instantly adjust to the same width.

If a column doesn’t change, it’s likely because you manually set its width earlier. Remove its custom width first if you want it to follow the default size.

Using Paste Special: Column Widths

Using the Paste Special – Column Widths option is a smart way to make multiple columns in Excel match the width of a single column. Instead of guessing or typing a width value, you copy the exact width from one column and apply it to others.

This method is particularly useful when you need a one-time fix and speed matters more than creating a formal layout or template. Imagine you are cleaning up a shared spreadsheet for a meeting, and you need all the columns to look aligned immediately. With just a few clicks, you can copy the width and apply it to the rest, saving you from manually adjusting each one.

Click the header of the column that already has the width you want to use. Make sure you select the entire column, not just a single cell.

Press Ctrl + C to copy that column. You will see a moving dotted border around it, confirming it’s copied.

Select the headers of the columns where you want to apply the same width. Hold the Ctrl key while clicking if you need to select non-adjacent columns.

Right-click on any of the selected headers and choose Paste Special from the context menu. A Paste Special dialog box will appear with several options.

In the dialog box that pops up, check Column widths, and click OK.

All selected columns will immediately adjust to match the width of the copied column.

Using a Keyboard Shortcut

Using a keyboard shortcut to make columns the same width in Excel is one of the fastest ways to tidy up your spreadsheet. Instead of navigating menus or dragging column borders, you press a sequence of keys to open the column width box instantly.

This approach is ideal when you need a quick, occasional solution without going through templates or complex setups. Now, let me introduce you to the quick steps that I often use to make column widths the same size:

Select the headers of the columns you want to resize. Click and drag across adjacent columns.

Hold Ctrl while clicking if columns are scattered.

Press Alt, then press H, then O, and finally W, one key at a time. Don’t press them together; tap them in sequence to open the Column Width dialog box.

In the Column Width dialog box, type the width you want, and click OK. You can use whole numbers or decimals, depending on how much space your data needs.

All the selected columns will instantly change to the same width.

If you need to adjust again, repeat the shortcut. It’s faster than guessing and dragging borders with your mouse.

Another way to bring up the Column Width tool is by using the right-click context menu.

Select a few columns and right-click.

Select the Column Width option from the context menu.

Now, enter a column width value that you prefer and click OK to apply.

Using the Format Painter Tool

Sometimes, you need to ensure that all other columns in the worksheet match a source column in their width. Here steps in the Format Painter tool. It lets you copy the column width from one column and transfer that to one or more columns in the active or other worksheets of the same workbook. And not just this, you can transfer the column width to other worksheets in other workbooks as well.

This method is perfectly suitable for you if you’re looking for a quick yet one-click solution to make Excel columns the same size. Now let’s get started with the steps below:

Click the header of the column that already has the width you want to copy. Make sure you select the column header, not just a single cell inside it.

The column header or label is the alphabet at the top of the column. Refer to the screenshot for clarity. It’s not the text or value in A1, B1, C1, etc., cells that you use as column headers for your data.

Go to the Home tab and click the Format Painter button in the Clipboard group. If you need to apply it to multiple columns, double-click the Format Painter instead of single-clicking.

Click the header of the column you want to change. The width will instantly adjust to match the copied column.

If you double-clicked the Format Painter, continue clicking other column headers to apply the same width. When you’re done, press Esc to turn off the Format Painter.

If the width doesn’t change, check if the target column was manually resized before. Reset it to the default and try again for the change to apply correctly.

Set Column Width Using Excel VBA

When you need to set the same column width in multiple worksheets and workbooks, you can use Excel VBA to automate the work. You only need to create the macro once in the Personal Macro Workbook project, and it becomes accessible from all Excel workbooks.

Setting up a VBA macro from a VBA script is easier than you think. Follow along with me as I show you the process step by step.

Firstly, access the following Excel VBA guide and find out how to create a VBA macro from scratch using a VBA script:

📒 Read More: How To Use The VBA Code You Find Online

Now, open your Excel workbook where you need to make the adjustments in column width. Then, follow these steps:

Go to the View tab, click on the Macros command, and select Record Macro from the context menu.

In the Store macro in the drop-down, select Personal Macro Workbook.

Record any random action, then stop recording. Excel will create PERSONAL.XLSB automatically.

Now, create a VBA macro in the VBAProject (PERSONAL.XLSB) folder of the Excel VBA Editor interface using the following VBA script:

Sub AdjustColumnWidth()
    Dim selectedRange As Range
    Dim choice As String
    Dim sourceColumn As String
    Dim customWidth As Variant
    Dim copiedWidth As Double
    Dim col As Range
    
    ' Ask user to select the columns
    On Error Resume Next
    Set selectedRange = Application.InputBox( _
        Prompt:="Select the columns where you want to adjust the width (use mouse to select).", _
        Title:="Select Columns", Type:=8)
    On Error GoTo 0
    
    If selectedRange Is Nothing Then
        MsgBox "No columns selected. Operation canceled.", vbExclamation
        Exit Sub
    End If
    
    ' Ask user to choose between copy or custom width
    choice = Application.InputBox( _
        Prompt:="Type 'C' to copy width from another column or 'W' to set a custom width value.", _
        Title:="Choose Method", Type:=2)
        
    If StrComp(choice, "C", vbTextCompare) = 0 Then
        ' Copy width from another column
        sourceColumn = Application.InputBox( _
            Prompt:="Enter the column letter (e.g., A) from which to copy the width.", _
            Title:="Source Column", Type:=2)
        
        If sourceColumn = "" Then
            MsgBox "No source column entered. Operation canceled.", vbExclamation
            Exit Sub
        End If
        
        copiedWidth = Columns(sourceColumn).ColumnWidth
        
        For Each col In selectedRange.Columns
            col.ColumnWidth = copiedWidth
        Next col
        
        MsgBox "Column widths successfully copied from column " & UCase(sourceColumn) & ".", vbInformation
        
    ElseIf StrComp(choice, "W", vbTextCompare) = 0 Then
        ' Set custom width
        customWidth = Application.InputBox( _
            Prompt:="Enter the custom column width value (e.g., 15 or 20.5).", _
            Title:="Custom Column Width", Type:=1)
        
        If customWidth = False Then
            MsgBox "No custom width entered. Operation canceled.", vbExclamation
            Exit Sub
        End If
        
        For Each col In selectedRange.Columns
            col.ColumnWidth = customWidth
        Next col
        
        MsgBox "Custom column width set to " & customWidth & " for the selected columns.", vbInformation
        
    Else
        MsgBox "Invalid choice. Please run the macro again and choose either 'C' or 'W'.", vbCritical
    End If
End Sub 

When the macro is ready, press Alt + F8 to launch the macro dialog box.

Select the AdjustColumnWidth macro from the list of macros and click on the Run button to execute it.

You’ll see a series of dialog boxes too walk you through the column width adjustment process.

The first input box will ask you to choose one or a range of columns for adjusting column width.

The second input box will ask you to enter C if you wish to copy column width from a column, or enter W if you wish to set a custom column width.

Type C to copy column width.

There will be a third dialog box where you need to enter the column letter from which you wish to copy the column width. For example, A for column A.

The Excel VBA macro will copy the column width to match it to all the columns.

However, you can also type W to instruct the macro to use a decimal value for custom width.

Enter the column width in the next input box as decimal or fraction values.

That’s it! Excel VBA will adjust the column width so it matches across columns.

Conclusions

So far, you learned five easy and popular methods to make Microsoft Excel columns the same width. Which one did you like the most? Share your opinion in the comment box.

If you liked this Excel tutorial, consider sharing it in social media groups of your friends and colleagues so they can also learn an important Excel skill.