absolute references

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Absolute references

Absolute references

resolvedResolved · Low Priority · Version Standard

Ben has attended:
Excel Introduction course
Excel Intermediate course

Absolute references

is the $ sign the only key for creating an absolute reference?

RE: absolute references

Hi Ben

Thank you for your question.

Yes, any cell reference that has $ signs in front of the column letter and row number is an absolute reference. This is the only way that Excel will understand that the cell needs to remain 'fixed' or 'locked' when the formula you have created is copied to other cells in the spreadsheet.

Amanda


 

Excel tip:

Adding up rows or columns without seeing formulas

Highlight a column or row and click the Autosum button. This gives you your answer without showing the formula.

View all Excel hints and tips


Server loaded in 0.12 secs.