Excel Formula?

L

Loreilor

How do I copy and paste a formula that automatically changes its references
according to its position on the worksheet?
 
B

Bob Phillips

Make sure that the formula does not have $ signs, e.g. change

=$A$1*17 to

=A17*17

--

HTH

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

RagDyeR

Select the entire formula in the formula bar.
Right click and choose "Copy".
Hit <Enter>.
Navigate to new cell.
Right click in new cell and choose "Paste".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

How do I copy and paste a formula that automatically changes its references
according to its position on the worksheet?
 
Top