I have a column about 900 cells long (from a web page table import each day that changes) I want to copy to another column and make all the cells absolute so I can position the copied cells however I want and they retain the original data. I know about the "=sum($A$1)" technique and the "F4" short cuts, but they are only good for working with individual (or small number of) cells. If I copy/paste a column of 900 cells, how can I easily make the complete column Absolute?