microsoft-excel-courses - Absolute Reference

Hi Emily

Thank you for your question.

You can remove an absolute reference from a formula by removing the $ signs from around the cell where they appear in the formula.

If you select the cell with the formula in it, then edit the formula to delete the $ signs this means that the cell reference is no longer absolute.

Amanda