Excel 365 - Maintain Column Width Paste Option Deletes Data

Question

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

Answer 1

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

Answer 2

Hi Qing

Sorry for slow response, weekends and public holidays here!

We are using Office 365 Pro Plus, the Excel version is 1904 (Build 11601.20230)

Many thanks.

Cheers

Bill

Answer 3

Hi Bill,

Thanks for your updates.

According to your Office version, it is not the newest version, we have released more newer Office version, I suggest you update Office to check the result:

1. Open Excel.
2. Click File>select Account.
3. Click Update Options>select Update now.

Regards,

Qing

Answer 4

Hi Qing

Thank you for the feedback. I will try to update myself, failing that I will ask our ICT department to assist.

I will let you know how we get on.

Cheers

Bill

Answer 5

Hi Bill,

Thanks for your reply.

You are welcome to post back after updating Office, I will try my best to help you.

Regards,

Qing