Add identical $ amount to group of cells

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
 
A

Alan

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,
 
A

Anders S

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
 
D

Dave R.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top