Thread: How do I add 100 to multiple cells?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
daddylonglegs daddylonglegs is offline
external usenet poster
  
Posts: 287
Default How do I add 100 to multiple cells?
Assuming you want to add 100 to a range of cells,

Put 100 in any empty cell and copy that cell

Select your range and use

Edit Paste Special Under "operation" select "add"

"Ed" wrote:


--
Ed
Reply With QuoteReply With Quote