microsoft-excel-courses - absolute reference

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

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

microsoft-excel-courses - Absolute Reference

resolvedResolved · Low Priority · Version 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:

Jumping Between Sheets in a Book

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Ctrl+PgDn and Ctrl+PgUp keys jump from one sheet in your workbook to the next, up or down through the pages.

View all Excel hints and tips


Server loaded in 0.09 secs.