How do I add 100 to multiple cells?

D

daddylonglegs

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"
 
B

Bob Phillips

Put 100 in a separate cell, then copy that cell

Select the cells to add to
Menu Edit>PasteSpecial
Click Add
OK

Clear the cell with 100 in it.

--
HTH

Bob Phillips

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

Jay Somerset

Put 100 in an unused cell, and copy it to the clipboard (cntl-C). Then,
select all the cells to which you want to add 100, and go to
EDIT Menu | Paste Special | click the ADD button under "operation" | then
click OK.
 
P

Prasadkakarla

Hello ED
Many experts gave the answer for u r question from my side also same answer
but in different way may be it is useful for u in short method.

Step I : Type 100 (u r req no) in anyother cell except the region (which
no's u want to add)
Step II: Just copy the 100 (or ur req no)
Step III: select the region where u want to add
Step IV: Just right click the mouse, in that there is paste , Paste special
is available
Step V: Please select the Paste special , one more dialog box open,in that
Options select ADD button, then OK
Step VI : once u enter the OK button immediately you will get all the
numbers with add of req number like e.g 100

Thank u
 
E

Ed

Hi Prasadkakarla,

Thanks for the help.
--
Ed


Prasadkakarla said:
Hello ED
Many experts gave the answer for u r question from my side also same answer
but in different way may be it is useful for u in short method.

Step I : Type 100 (u r req no) in anyother cell except the region (which
no's u want to add)
Step II: Just copy the 100 (or ur req no)
Step III: select the region where u want to add
Step IV: Just right click the mouse, in that there is paste , Paste special
is available
Step V: Please select the Paste special , one more dialog box open,in that
Options select ADD button, then OK
Step VI : once u enter the OK button immediately you will get all the
numbers with add of req number like e.g 100

Thank u


--
Name : K.Prasad
Inventory Manager
CRYSTALGALLERY
DUBAI
Click to expand...
 
Top