Sometimes you spend a lot of time and effort getting the columns on a worksheet to the exact widths that you want and then need to copy and paste the data elsewhere. The last thing you want is to then spend time adjusting column widths again!
To copy column widths:
- Copy the data as usual.
- Click in the location in which you want to paste the data.
- Click on the Paste dropdown.
Find out more about our Microsoft Excel training in the London area.
Find out more about our Microsoft Excel training in Wiltshire, Dorset, Hampshire and Somerset.