Paste Special not avail in excel web? Cannot copy/paste column width.

New Contributor

I'm trying to copy and paste column widths and the option to Paste Special is not an option in the excel web version. How do I copy and paste keeping column widths on web? 

2 Replies

@EmilyCMB Indeed! The web version has fewer paste options. But since "column width" is a type of formatting, you could perhaps use "Paste Formatting" as an alternative. Obviously, that will also paste all other formats of that particular column.

Screenshot 2022-03-19 at 06.16.54.png

@Riny_van_Eekelen Thank you, yes... I did try paste formatting and it still didn't paste the adjusted width. Really wish the web version had more functionality!