Thread: ADDING A NUMBER
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Gordon Gordon is offline
external usenet poster
 
Posts: 161
Default ADDING A NUMBER

"Max" wrote in message
...
"Helpme" wrote:
how do i add a number to a range of cells? I need to add 11.27 to a
number
of different cells each with a different number in them


Enter in a cell: 11.27
Copy that cell

Hold down CTRL and click/select all the different cells
Right-click on the selection Paste special Check "Add" OK
That should do it all at one go

Clean up by clearing the cell with the "11.27" in it


No audit trail of the change. That's the problem with that method....