Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft-excel-courses - absolute reference

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Absolute Reference

microsoft-excel-courses - Absolute Reference

ResolvedVersion Standard

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

Excel tip:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.

=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.