View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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