Match Multiple Column Group Widths in Excel for Mac
Question details
Match the widths of one group of Excel columns to another while preserving the different widths within the group.

- 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.
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.
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.
Click the first source column header, then choose Format > Column > Width and record the displayed value.
Select each remaining source column header in turn and use Format > Column > Width to record its width.
Select the first destination column header, choose Format > Column > Width, enter the corresponding source width, and click OK. Repeat for each remaining destination column.

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. Open the workbook: Open WPS Spreadsheet and select Open to load your Excel workbook.
- 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. Apply the matching widths: Select each destination column in turn, choose Home > Format > Column Width, and enter the corresponding recorded value.
- 4. Save the workbook: Choose File > Save or Save As to save the updated spreadsheet.

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.




