Excel Formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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?
 
You must log in or register to reply here.

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

Copying formulas with relative references 2
Excel Sequential Numbering System 0
how to calculate hrs flown in last one year 0
Excel Help to copy information from one row at a time to another sheet 1
Copy worksheet to new doc w/formulas not referencing previous doc 4
formulas change when copied 6
Why did auto calculate suddenly change to manual calcu... 4
copy formulas from one worksheet to an entirely different workshee 2

Back
Top