Office for Mac Issues

Match Multiple Column Group Widths in Excel for Mac

Aamir Naveed AkramAamir Naveed Akram Nov 18, 2026 870 views

Question details

Match the widths of one group of Excel columns to another while preserving the different widths within the group.

Match Multiple Column Group Widths in Excel for Mac
Product
Microsoft Excel for Mac
Device & OS
Mac
Scenario
The user wants a destination group of columns to follow the same width pattern as a source group.
Observed behavior
Resizing multiple selected columns together applies the same width to all of them rather than copying a pattern of different widths.
Before you start

Identify the source and destination column groups and match each destination column to its corresponding source column. For example, columns A–D can be matched to columns E–H in order.

Solution 1Recommended

Set Each Destination Column to Its Matching Width

Use this method to reproduce a group of different column widths without making every selected column the same width.

1
Check the first source width

Click the first source column header, then choose Format > Column > Width and record the displayed value.

2
Record the remaining widths

Select each remaining source column header in turn and use Format > Column > Width to record its width.

3
Set the destination widths

Select the first destination column header, choose Format > Column > Width, enter the corresponding source width, and click OK. Repeat for each remaining destination column.

Set Each Destination Column to Its Matching Width
Avoid resizing the whole group at once: Dragging a boundary while multiple columns are selected gives those columns the same width; it does not preserve a pattern of different widths.
Match column widths

Recreate Column Width Patterns in WPS Spreadsheet

Use the column width settings in WPS Spreadsheet to record each source width and apply it to the matching destination column.

  1. 1. Open the workbook: Open WPS Spreadsheet and select Open to load your Excel workbook.
  2. 2. Check each source width: Select a source column header and choose Home > Format > Column Width. Record the value, then repeat for the other source columns.
  3. 3. Apply the matching widths: Select each destination column in turn, choose Home > Format > Column Width, and enter the corresponding recorded value.
  4. 4. Save the workbook: Choose File > Save or Save As to save the updated spreadsheet.
Preserve different widths within a column groupOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceWork with spreadsheets in WPS Office for free
microsoft office alternative - wps office

Frequently Asked Questions

Can I copy several different column widths by dragging one boundary?

No. Dragging a boundary with multiple columns selected applies one width to the selected columns. Set each destination column separately to preserve the source pattern.

Where can I find a column's exact width in Excel for Mac?

Select the column header, then choose Format > Column > Width to see its current width.

Can VBA match a column width pattern in Excel?

Yes. A VBA macro can read the ColumnWidth property of each source column and assign it to the corresponding destination column. This can be useful when you need to repeat the task.

Can I match column widths in an Excel file with WPS Spreadsheet?

Yes. Open the workbook in WPS Spreadsheet, use Home > Format > Column Width to check each source width, and enter those values for the corresponding destination columns.