. . or is this what you want:-

- click on letter at top of column to highlight whole column

- right click / Copy

- go to destination column / highlight whole column again by clicking in
column header letter then right click and Paste.



"james" wrote:

Hi again, thanks for the help, im trying to repeat a formula for all cells in
a column, is there an easy way of doing this?
Thanks
James