How do I add to figures already in a cell?

[bella393]

I have a long pricelist of items that I offer for wholesale. There are
over 5000 items and the prices were just recent raised. I want each
item to reflect the price increase of $20,but I dont want to have to
sit there are edit each and every cell. I have 3 cells going across,
reflectin different prices for different quantities of the same item,
so if I do each one by one, that is 15000 edits I have to do manually.


I would like to add the $20 increase to each cell but do it for all the
cells at once with a formula. If this is possible please let me know.
Any help is appreciated!

 

[Pete]

In a blank cell somewhere enter 20, then <copy> this value. Then
highlight your 3 columns with the prices in and Edit | Paste Special |
Values (select) and Add (select), then click OK and <esc>. This will
add 20 to all 15,000 values in one operation.

Hope this helps.

Pete

 

[bella393]

Oh! I would also like to know how to add a picture in the background of
my excel sheet. Thanks!

 

[bella393]

Thank you Pete! That worked! What a time saver

 

[L. Howard Kittle]

Check out Insert > Picture > 6 choices from where

HTH
Regards,
Howard