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

Thank you that helped a bunch

"Max" wrote:

"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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---