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

relative references

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Relative References

Relative References

ResolvedVersion 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:

Adjusting the Elevation and Rotation in a 3-D Chart

For any 3-D chart you create, you can adjust the chart

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.1 secs.