Leading the way in Microsoft Office Development

Step 1 - Relative Row References

You can use the Fill Handle to quickly copy your formulas to other cells.

Any formulas that contain relative cell references will be automatically changed to reflect their new relative addresses.

Dragging the Fill Handle when the selected cell contains a formula will continue the formula in the subsequent cells.

You can drag your formulas across the worksheet as well as down using the Fill Handle.

Step 2 - Absolute References

If any of the cell references are absolute references meaning they are prefixed with a dollar sign then the cell references will not change and will remain the same.

Step 3 - Things to Remember

Copying formulas using the fill handle is a quick way to copy the same formula into a range of cells.