Steps to copy in Excel with formula
- Step 1: Create a formula in a cell using relative or absolute references as needed.
(Example: =A1 + B1)
- Step 2: Copy the cell that contains the formula, then paste it into other cells that align with the same structure as the original formula.
- Step 3: You'll see that the pasted cells carry the same formula logic but return different results based on the values in their respective rows or columns.
Result: Excel automatically adjusts the formula references to match the new positions.
Tip: Use $ symbols to lock references if you don’t want them to change when copying—like $A$1 for an absolute reference.