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
|