Convert Relative to absolute address

R

Rick Rothstein \(MVP - VB\)

How can I convert a relative address to an absolute address in Excel?

Put $ signs in front of the parts of the address that you want to be
absolute.

Rick
 
G

Guest

The problem I have is that I have a number of formulas refering to a relative
address and I wish to have them refer to absolute. I am trying to avoid
redoing all references by adding the $ to each one.
 
G

Guest

Look at EDIT=>Replace

Yorke said:
The problem I have is that I have a number of formulas refering to a relative
address and I wish to have them refer to absolute. I am trying to avoid
redoing all references by adding the $ to each one.
Click to expand...
 
R

RagDyer

This is more easily accomplished by clicking in the cell with the formula
and then click in the formula bar on the cell address you wish to revise.
Then hit <F4> and you will automatically add absolute attributes.
Each time you hit <F4>, you'll see the references rotate through the various
absolute instances.

If you select the *entire* formula in the formula bar, *every* reference
will change at the same time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Range of cells: Convert relative reference into absolute 5
Convert selected formula references from relative to absolute 6
Absolute and Relative Cell References 1
Switch between relative, absolute, and mixed references 3
Copy formatting, Help 9
Change Excel column headers from numbers to letters 1
Hyperlinks changed by Excel again! 5
Change a cell reference from relative to absolute 2

Top