|
Hi,
In this section I'll be including more tips and tricks, along with some advice and stories from the world of PCs.
I've often had it mentioned to me by delegates on courses that they find it annoying that when pasting, the column width does not change to match the copied column. This is especially galling when copying a large amount of data, such as a whole sheet.
It's quite easy though to copy the column widths.
. Paste as normal - you may find the data does not 'fit'
. Right click on the selected range of data you have pasted
. Click Paste Special on the pop-up menu, and select the Column Widths option button.
More tricks and shortcuts every day at Twitter – http://twitter.com/PCshortcuts
| 
Blog
