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

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

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

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

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

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

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