I had series of prices on cell A. I want to increase those prices from
A1:A10000 by 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%

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%