Relative and Absolute Cell References

Learn the difference between a relative absolute cell reference in Excel and an absolute cell reference in Excel in this free lesson.

Challenge!

  1. Open an existing Excel workbook. If you want, you can use our practice workbook.
  2. Create a formula that uses a relative reference. If you are using the example, use the fill handle to fill in the formula in cells E4 through E14. Double-click a cell to see the copied formula and the relative cell references.
  3. Create a formula that uses an absolute reference. If you are using the example, correct the formula in cell D4 to refer only to the tax rate in cell E2 as an absolute reference, then use the fill handle to fill the formula from cells D4 to D14.
  4. Try referencing a cell across worksheets. If you are using the example, create a cell reference in cell B3 on the Catering Invoice worksheet for cell E15 on the Menu Order worksheet.