MrExcel Publishing
Your One Stop for Excel Tips & Solutions

absolute


Posted by Stephen Guarnieri on October 03, 2001 8:15 AM

How would you define a cell as absolute? What is the difference between relative and absolute addresses?


Posted by Barrie Davidson on October 03, 2001 8:20 AM

I don't know why you need this because it WON'T be available to Excel, put a couple of double quotes when you are saving it, like this:

"882900201.1590"

Instead of just

882900201.1590

Juan Pablo

Posted by Barrie Davidson on October 03, 2001 8:21 AM

A relative address will change if you copy the formula to another cell, an absolute will not. For example, the formula =A1 is a relative address and if you copy it down one row it will become =A2. The formula =$A$1 is an absolute address; if you copy it down one row it will stay =$A$1. The $ sign indicates an absolute to Excel and can be put in front of the column, the row, or both.

Hope this answers your question.

BarrieBarrie Davidson

Posted by IML on October 03, 2001 9:00 AM

somewhat useless info

If you need to change your references, you can select a cell, highlight the formula in the formula bar and hit F4 to run through the absoluting options. It also works if you highlight individual cell addresses and hit F4 within the formula bar.

Posted by Eric on October 03, 2001 9:14 AM

Cool! (NT)