I want to copy a column in which certain cells have formulas and/or
formatting applied, and paste it to an adjacent column which has just been
added to the sheet. However, when I choose 'Paste Special' 'Formulas and
number formats', I find that values from cells which contain only data are
pasted into the adjacent cell, i.e. it is not just 'Formulas and number
formats' which get pasted. Is there a way around this, other than copying and
pasting one-by-one the cells which have formulas and/or formatting applied?