Emily has attended:
Excel Intermediate course
Absolute Reference
How do you remove the absolute reference from a cell?
RE: 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