When you copy a formula, Excel automatically adjusts the cell references for each new cell the formula is copied to. If you don't want this but instead want to copy the exact formula (without changing the cell references), execute the following easy steps.

*Now we can copy this formula to the rest of the cells in the table by using the fill handle. Grab the fill handle and drag it down to cover the whole column. Excel is smart enough to replace the row numbers in each cell, so we get the difference between the appropriate entries in the two sheets:*The simplest thing you can do is add formulas that refer to the cells in sheet 1 containing the information you want to replicate. So a simple =Sheet1!A1 should be enough. When I add a new row in to one of these sections to add a new product and update the price, I have to hit CTRL+D to bring the formula down. What I want is for this formula to come down automatically once a new row is entered in one of these sections. When I add a new row in to one of these sections to add a new product and update the price, I have to hit CTRL+D to bring the formula down. What I want is for this formula to come down automatically once a new row is entered in one of these sections. The simplest thing you can do is add formulas that refer to the cells in sheet 1 containing the information you want to replicate. So a simple =Sheet1!A1 should be enough.