Change a cell reference from relative to absolute


F

Fred Holmes

Excel 2000

When I "automatically" generate a cell reference in a formula by
clicking on the source cell, the reference is generated as a relative
reference rather than an absolute reference. This is OK when the
source cell is in the same worksheet in the workbook, but is "not
useful" when the source cell is in a different worksheet. Currently I
am editing the cell reference manually.

Is there a way to change the cell reference generation to absolute, or
to flip (with a keystroke or a toolbar button, etc.) the reference
from relative to absolute?

e.g., in R1C1 notation.

change:

=[other sheet]!R[-4]C[-3]

which is what is generated automatically

to

=[other sheet]!R47C5

I seem to recall reading about doing this in the past, but I can't
find a search term to use in the help system to bring it up.

TIA

Fred Holmes
 
Ad

Advertisements

S

Sheeloo

While entering/editing the formula pressing F4 cycles through the four
posssibilities ...
R[-4]C[-3]
R4C3
R4C[-3]
R[-4]C3
 
Ad

Advertisements

D

Dave Peterson

Select the cell with the formula
Select the entire formula in the formula bar.
Hit F4 to cycle through the absolute and relative references.



Fred said:
Excel 2000

When I "automatically" generate a cell reference in a formula by
clicking on the source cell, the reference is generated as a relative
reference rather than an absolute reference. This is OK when the
source cell is in the same worksheet in the workbook, but is "not
useful" when the source cell is in a different worksheet. Currently I
am editing the cell reference manually.

Is there a way to change the cell reference generation to absolute, or
to flip (with a keystroke or a toolbar button, etc.) the reference
from relative to absolute?

e.g., in R1C1 notation.

change:

=[other sheet]!R[-4]C[-3]

which is what is generated automatically

to

=[other sheet]!R47C5

I seem to recall reading about doing this in the past, but I can't
find a search term to use in the help system to bring it up.

TIA

Fred Holmes
 

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

Top