relative 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 » Relative References

Relative References

resolvedResolved · Low Priority · Version 2007

Anne has attended:
Excel Intermediate course
Excel Advanced course

Relative References

What can relative references be used for?

RE: Relative References

Hello Anne

Thank you for your question.

A relative reference is a cell reference in a formula that will change to a different reference when the formula is copied to other cells in the spreadsheet.

This is generally useful as it allows you to create a formula and reuse it in other places in your spreadsheet.

You are also able to create absolute references and mixed references in formulas.

Kind regards
Amanda

Thu 19 Feb 2009: Automatically marked as resolved.


 

Excel tip:

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake.

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips


Server loaded in 0.09 secs.