I want to subtract a number from an entire row in excel
Put 2000 in a spare cell, copy, select your row, Edit/ Paste Special/
Subtract/ OK
You can now delete the 200 from the spare cell, if you wish.
--
David Biddulph
"kav" wrote in message
...
I want to subtract a constant number say 2000 fro an entire row and replace
the same row with the new answer
|