how can i raise row of list prices to 10% higher

[mowerman]

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

[Ron Coderre]

Try this:

Enter 1.1 in a blank cell
Edit>Copy

Select your range containing current prices
Edit>Paste 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

[Ken Wright]

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" <mowerman@discussions.microsoft.com> wrote in message
news:D3703401-555B-4C3D-B94F-96EEC6E1318E@microsoft.com...
> 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

[Gary''s Student]

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

[mowerman]

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" <mowerman@discussions.microsoft.com> wrote in message
> news:D3703401-555B-4C3D-B94F-96EEC6E1318E@microsoft.com...
> > 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
>
>
>

[mowerman]

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

[mowerman]

thanks for the tip it worked perfect

"Ron Coderre" wrote:

> Try this:
>
> Enter 1.1 in a blank cell
> Edit>Copy
>
> Select your range containing current prices
> Edit>Paste 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