software

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

Try this:

Enter 1.1 in a blank cell
Editgt;Copy

Select your range containing current prices
Editgt;Paste Specialgt;
Check: Values
Check: Multiply
Click the [OK] button

That should do it!

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;mowermanquot; wrote:

gt; at our store we have price sheets in excell and i want to raise the list
gt; prices all at one time to 10% higher . can i do this and how

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 amp;
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 :-)
------------------------------*------------------------------*----------------quot;mowermanquot; gt; wrote in message
news
gt; at our store we have price sheets in excell and i want to raise the list
gt; prices all at one time to 10% higher . can i do this and how
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 Studentquot;mowermanquot; wrote:

gt; at our store we have price sheets in excell and i want to raise the list
gt; prices all at one time to 10% higher . can i do this and how

thanks for the tip , it worked perfect!

quot;Ken Wrightquot; wrote:

gt; Do you want to lose the existing values?
gt;
gt; 1) Keeping existing values, simply use another column and use a formula such
gt; as =A2*1.1 and copy down.
gt;
gt; 2) Replacing existing values, put 1.1 in any empty cell, then copy that
gt; cell. Select all your values and then do edit / paste special / values amp;
gt; multiply
gt;
gt; --
gt; Regards
gt; Ken....................... Microsoft MVP - Excel
gt; Sys Spec - Win XP Pro / XL 97/00/02/03
gt;
gt; ------------------------------Â*------------------------------Â*----------------
gt; It's easier to beg forgiveness than ask permission :-)
gt; ------------------------------Â*------------------------------Â*----------------
gt;
gt;
gt; quot;mowermanquot; gt; wrote in message
gt; news
gt; gt; at our store we have price sheets in excell and i want to raise the list
gt; gt; prices all at one time to 10% higher . can i do this and how
gt;
gt;
gt;

thanks for the tip it worked perfect

quot;Gary''s Studentquot; wrote:

gt; 1. Put 1.1 in an un-used cell and copy the cell
gt; 2. Select all the cells you want to increase and then paste/special with the
gt; multiply botton set
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;mowermanquot; wrote:
gt;
gt; gt; at our store we have price sheets in excell and i want to raise the list
gt; gt; prices all at one time to 10% higher . can i do this and how

thanks for the tip it worked perfect

quot;Ron Coderrequot; wrote:

gt; Try this:
gt;
gt; Enter 1.1 in a blank cell
gt; Editgt;Copy
gt;
gt; Select your range containing current prices
gt; Editgt;Paste Specialgt;
gt; Check: Values
gt; Check: Multiply
gt; Click the [OK] button
gt;
gt; That should do it!
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;mowermanquot; wrote:
gt;
gt; gt; at our store we have price sheets in excell and i want to raise the list
gt; gt; prices all at one time to 10% higher . can i do this and how