Share via

Excel 365 - Maintain Column Width Paste Option Deletes Data

Anonymous
2019-09-12T10:38:14+00:00

Hi

I have just moved from 2016 to 365 on a new laptop. When pasting data in Excel into a new table, the maintain column width option just clears all the data from the cells? All other options seem fine.

Any ideas on how to correct? Maybe should move back to 2016!

Cheers

Bill

Microsoft 365 and Office | Excel | For home | 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
Answer accepted by question author
  1. Anonymous
    2019-09-12T14:44:14+00:00

    Hi Qing

    This is the paste option I used in the quick access after pasting. I have tried this several times since converting to 365, and it always blanked out the cells.

    When performing the function again now to show you, it no longer clears the cells and expands the columns to their pre-copied widths!

    I do not know why it now works, but I have witnesses...?? :-) 

    Thank you for your response and time.

    Cheers

    Bill

    0 comments

8 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-09-12T14:15:18+00:00

    Hi Bill,

    Thanks for posting the question on our forum.

    According to your description, I want to confirm if you refer to the following steps to paste via the special option:

    1. Select the data to copy.
    2. Select the table where did you want to paste, right click it.
    3. Select Paste special.
    4. Select Column widths as below:

     

    If so, the option only pasted the widths of the cell not including the cell data.

    If this is not your situation, you are welcome to post back and provide the detailed steps to use the option, I will keep working on this and try my best to help you.

    Regards,

    Qing

    0 comments
  2. Anonymous
    2019-09-15T21:35:15+00:00

    Hi Bill,

    Thanks for your updates.

    I am very happy to hear that the issue has disappeared.

    If the issue occurs again, we will try our best to help you.

    Regards,

    Qing

    0 comments
  3. Anonymous
    2019-09-18T14:47:09+00:00

    Hi Qing

    It is happening again, but I think I have narrowed it down to pasting from a filtered list!

    Cheers

    Bill

    0 comments
  4. Anonymous
    2019-09-19T15:46:19+00:00

    Hi Bill,

    Thanks for your reply.

    According to your description, I have done the test on the newest version of Office, I didn't meet the issue on our side.

    1. Create a new table.
    2. Filter it.
    3. Copy the content.
    4. Select the option "Keep Source Column Widths" to paste it.

    If the issue still exists, could you please provide the Office version, I will tested it on our side with the same version. (Click File>select Account)

    Regards,

    Qing

    0 comments