How do I add one number to all cells in excel?

B

Ben

I create a price list with numbers in almost every column and every row of a
worksheet. Some customers have rebates that I need to add .02 or .03 cents
to. Is there a way to add these rebate numbers to all the individual values
in each cell of excel?
 
B

Bob Phillips

Put .02 in a cell and copy that cell

Then select all the cells you want to add it to, goto Edit>Pastespecial, and
click the Add button in the Operations section.

Finally, clear the .02 cell and repeat for .03.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top