On my spreadsheet I have a formula for column c where column d is multiplied by a number and it auto updates the value to column c. It is working fine. However I need to add more columns on my sheet. I have tried to highlight, copy, paste, etc., but cannot get the formula to continue further down the page. can someone help me out? I am sure it is very simple to do as I set the spreadsheet up in Jan of this year and cannot for the life of me remember how to do this one step. Thanks in advance.