Copying exact formula instead, rather than with usu. Excel's helpful cell adjustments/increments?

S

StargateFan

Excel's mthod of copying formulas while taking into account new cells
is usu. really vital. i.e., a formula in A1 when copy/pasted into B1
automatically copies adjusted for B1, C1 will show C1, etc.

Every once in a blue moon, though, we need to copy the exact formula
when the information just needs to be replicated exactly in other
cells. Is there a special keystroke to do that?

Tx.
 
B

Bob Phillips

Set the cell references as absolute, e.g. $A$2 instead of A2

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
S

StargateFan

Set the cell references as absolute, e.g. $A$2 instead of A2
Click to expand...

Hey, that's what those mean! Of course I've seen this type of things
in some of the complex formulas some very kind people in these ngs
have provided but I never knew what they meant. Kewl.

Thanks, worked like a charm and much better an easier than remembering
some sort of keystroke. :eek:D
 
B

Bob Phillips

You can use a function key F4, to change it. Select the cell reference and
F4, it cycles through all combinations.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top