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

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)


"Loreilor" wrote in message
...
How do I copy and paste a formula that automatically changes its
references
according to its position on the worksheet?

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!
==============================================

"Loreilor" wrote in message
...
How do I copy and paste a formula that automatically changes its references
according to its position on the worksheet?