Jump to content

Adjust Column Widths When Pasting


Recommended Posts

Adjust Column Widths When Pasting

When you copy a range of data (several columns), you can't

automatically paste the column widths that accommodate your

data. You must first select the data you want to copy and

press Ctrl+C. Click a destination cell, and press Ctrl+V to

paste the data to the new range. Right-click the new range

and choose Paste Special. Select the Column Widths option

in the Paste section, then click OK. When you return to

your worksheet, the columns in the new range will be the

same width as the columns in the original range.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...