increase from A2 to A10000 by a percentage of 5%
 

I had series of prices on cell A. I want to increase those prices from
A1:A10000 by 5%

increase from A2 to A10000 by a percentage of 5%
 

First, copy the datalist format.

Click on a cell in the datalist and then click on the "Format Painter" icon
(yellow paintbrush) and then click in a new, empty, unused cell.

Now, in this formatted cell, key in 1.05.
Right click in this cell and choose "Copy".

Select the datalist, and right click in that selection.
Choose "Paste Special", and click on "Multiply", then <OK, then <Esc.

You can clear the cell containing the 1.05.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"blessolu" wrote in message
...
I had series of prices on cell A. I want to increase those prices from
A1:A10000 by 5%

increase from A2 to A10000 by a percentage of 5%
 

Try this...

Enter 1.05 in an empty cell
Copy that cell: EditCopy
Select the range A2:A10000
Then, EditPaste SpecialMultiplyOK
Delete the 1.05

--
Biff
Microsoft Excel MVP


"blessolu" wrote in message
...
I had series of prices on cell A. I want to increase those prices from
A1:A10000 by 5%