Add identical $ amount to group of cells

  • Thread starter Thread starter Eric W
  • Start date Start date
E

Eric W

I have imported price lists (via OmniPage)into Excel. We
would like to add a set dollar amount (our profit) to
each of the cells. (ie. Add $500 to each cell). Can we do
this globally?

Thank you very much in advance,
Eric
 
Enter 500 into an empty cell, right click it, Copy
Highlight all the cells you want to add 500 to,
Right click them, Paste Special, Check Add, OK
Delete the cell containing 500,
Regards,
 
Eric,

Enter 500 in any cell. Copy the cell and select the cells to be added to. Do Edit>Paste Special, click Add, then OK and you're done.

HTH
Anders Silven
 
Surely you can; select the cell containing your $500, copy it (CTRL C).

Select the range of cells you wish to add $500 to, then go to edit>paste
special>add then OK.

If you want to do this with multiple worksheets, you can group them (by
holding CTRL and clikcing on each one) then do the same, as long as you
always want to add to the same group of cells in each worksheet.
 
Back
Top