MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Coping formulas


Posted by R.Brayton on July 06, 2001 12:40 PM

Hi, I have a formula: =(ABS(A1+B1)=$C$1) My question is, how can I make this formula apply to all the rows on a work sheet without rewriting the formula for each row. Thanks for your help.


Posted by Scott S on July 06, 2001 1:18 PM

You should be able to copy and paste the formula as is, and it should apply. If you want the qualifier to change ($C$1), you can remove the "$". If this does not work for you, give me some more info so I can see how you are using this formula.

Posted by Kierrica Firson on July 06, 2001 1:20 PM

Copy the cell that has the formula, then highlight all the rows that you want to have the formula apply to. Then right-click on the highlighted portion, click "paste special," then under paste click "formulas." Hope that's what you wanted.