How do I add to figures already in a cell?
 

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!


--
bella393
------------------------------------------------------------------------
bella393's Profile: http://www.excelforum.com/member.php...o&userid=30744
View this thread: http://www.excelforum.com/showthread...hreadid=504109

How do I add to figures already in a cell?
 

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

How do I add to figures already in a cell?
 

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


--
bella393
------------------------------------------------------------------------
bella393's Profile: http://www.excelforum.com/member.php...o&userid=30744
View this thread: http://www.excelforum.com/showthread...hreadid=504109

How do I add to figures already in a cell?
 

Thank you Pete! That worked! What a time saver:)


--
bella393
------------------------------------------------------------------------
bella393's Profile: http://www.excelforum.com/member.php...o&userid=30744
View this thread: http://www.excelforum.com/showthread...hreadid=504109

How do I add to figures already in a cell?
 

Check out Insert Picture 6 choices from where

HTH
Regards,
Howard

"bella393" wrote in
message ...

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


--
bella393
------------------------------------------------------------------------
bella393's Profile:
http://www.excelforum.com/member.php...o&userid=30744
View this thread: http://www.excelforum.com/showthread...hreadid=504109