How to make all columns the same width in excel

Answer

To make all columns the same width in Excel, use one of the built-in column formatting commands that applies a uniform measurement to every selected column.

Using the Ribbon Method

1. Select the columns you want to standardize.

2. Go to the Home tab.

3. Select Format in the Cells group.

4. Choose Column Width.

5. Enter the numeric width value.

6. Select OK to apply the change.

Windows and Mac have identical steps for this method.

Using the Mouse Method

1. Select all target columns.

2. Move the pointer to the right edge of any selected column header.

3. Drag the boundary to set the exact width.

4. Release the mouse to apply the width to every selected column.

Windows and Mac support the same drag-to-resize action.

Using the Select-All Command

1. Press Ctrl + A on Windows or Command + A on Mac to highlight the entire worksheet.

2. Place the pointer on the right boundary of any column header.

3. Drag the boundary to the preferred width.

4. Release the mouse to apply the width to all columns in the sheet.

Using AutoFit for a Uniform Result

AutoFit sets the width based on content. AutoFit does not create identical widths. AutoFit only adjusts each column independently.
Uniform width requires a manual numeric value or a drag action.

Using the Right-Click Menu

1. Select the columns to update.

2. Right-click a selected column header.

3. Choose Column Width from the context menu.

4. Type the target value.

5. Select OK.

When the Standard Column Width Helps

The Standard Width setting determines the default width for new columns.
This setting does not change existing columns.
Manual resizing is required for columns already in use.

Keyboard Shortcut Case

Excel does not include a direct keyboard shortcut for setting identical widths.
A shortcut sequence exists:

1. Select the columns.

2. Press Alt, then H, then O, then W on Windows.

3. Type the width and confirm.

Mac does not support this key sequence.

Yes · 0 No · 0 Add Comment · 0

Add ·

Report