Relative Addresses

Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Excel and other Microsoft topics.

What is relative addresses?

Relative Addresses

A relative address is a standard cell reference that appears like this: A1,E15,M42. A relative address changes if you copy a formula that contains it to a new location on the worksheet.

   

Comments

Nobody has commented on this tip yet. Be the first.



Name:


URL: (optional)


Comment:


Not finding the advice and tips you need on this Microsoft Tip Site? Request a Tip Now!


Guru Spotlight
Byron White