Share via

copying column width from sheet to sheet

Anonymous
2023-06-05T22:09:27+00:00

In Excel how do you copy a col width from to another between sheets?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2023-06-05T22:22:42+00:00

    Select the column(s) whose width you want to transfer.

    Copy the selected range.

    Select the (first) column of the target range.

    Click the lower half of the Paste button on the Home tab of the ribbon.

    Select 'Paste Special...' from the drop down menu. (It is also available in the context menu when you right-click in the selected range)

    Select 'Column Widths' and click OK

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-06-06T03:01:35+00:00

    You can use Format Painter from one column to another one.

    0 comments