| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i raise row of list prices to 10% higher
at our store we have price sheets in excell and i want to raise the list
prices all at one time to 10% higher . can i do this and how |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i raise row of list prices to 10% higher
Try this:
Enter 1.1 in a blank cell EditCopy Select your range containing current prices EditPaste Special Check: Values Check: Multiply Click the [OK] button That should do it! Does that help? *********** Regards, Ron XL2002, WinXP-Pro "mowerman" wrote: at our store we have price sheets in excell and i want to raise the list prices all at one time to 10% higher . can i do this and how |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i raise row of list prices to 10% higher
thanks for the tip it worked perfect
"Ron Coderre" wrote: Try this: Enter 1.1 in a blank cell EditCopy Select your range containing current prices EditPaste Special Check: Values Check: Multiply Click the [OK] button That should do it! Does that help? *********** Regards, Ron XL2002, WinXP-Pro "mowerman" wrote: at our store we have price sheets in excell and i want to raise the list prices all at one time to 10% higher . can i do this and how |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i raise row of list prices to 10% higher
Do you want to lose the existing values?
1) Keeping existing values, simply use another column and use a formula such as =A2*1.1 and copy down. 2) Replacing existing values, put 1.1 in any empty cell, then copy that cell. Select all your values and then do edit / paste special / values & multiply -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "mowerman" wrote in message ... at our store we have price sheets in excell and i want to raise the list prices all at one time to 10% higher . can i do this and how |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i raise row of list prices to 10% higher
thanks for the tip , it worked perfect!
"Ken Wright" wrote: Do you want to lose the existing values? 1) Keeping existing values, simply use another column and use a formula such as =A2*1.1 and copy down. 2) Replacing existing values, put 1.1 in any empty cell, then copy that cell. Select all your values and then do edit / paste special / values & multiply -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------Â*------------------------------Â*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------Â*------------------------------Â*---------------- "mowerman" wrote in message ... at our store we have price sheets in excell and i want to raise the list prices all at one time to 10% higher . can i do this and how |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i raise row of list prices to 10% higher
1. Put 1.1 in an un-used cell and copy the cell
2. Select all the cells you want to increase and then paste/special with the multiply botton set -- Gary's Student "mowerman" wrote: at our store we have price sheets in excell and i want to raise the list prices all at one time to 10% higher . can i do this and how |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i raise row of list prices to 10% higher
thanks for the tip it worked perfect
"Gary''s Student" wrote: 1. Put 1.1 in an un-used cell and copy the cell 2. Select all the cells you want to increase and then paste/special with the multiply botton set -- Gary's Student "mowerman" wrote: at our store we have price sheets in excell and i want to raise the list prices all at one time to 10% higher . can i do this and how |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
| help with quote program using muliple prices for one quantity {cross post} | Excel Discussion (Misc queries) | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
| Creating a list from an existing list. | Excel Worksheet Functions | |||
Hybrid Mode
