Where would we be without Copy and Paste? Probably way behind schedule, or should I say, further behind schedule than we are currently! ?
In Excel, Copy and Paste copies everything by default… except column widths! This can be a little frustrating especially if that is one of the key things you require to copy.
There is a simple solution. Once pasted, click on the paste options and select “Keep source column width”. Even quicker is to use the Keyboard Shortcuts of ctrl and then W.
If you’d like to learn Excel on a deeper level, be sure to check out our online courses, ideal for both beginners as well as those wanting to further upskill their Excel knowledge.