| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I print formula figures and calculated amount in a cell? | Excel Discussion (Misc queries) | |||
| Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
| How to Copy the value of a cell to any given cell | Excel Discussion (Misc queries) | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Hybrid Mode
