View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ed Ed is offline
external usenet poster
 
Posts: 279
Default How do I add 100 to multiple cells?

Thanks Daddylonglegs & Bob. I knew there was a way to do this. Thanks again.
--
Ed


"Bob Phillips" wrote:

Put 100 in a separate cell, then copy that cell

Select the cells to add to
Menu EditPasteSpecial
Click Add
OK

Clear the cell with 100 in it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ed" wrote in message
...

--
Ed