increase from A2 to A10000 by a percentage of 5%

[blessolu]

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

 

[Ragdyer]

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.

 

[T. Valko]

Try this...

Enter 1.05 in an empty cell
Copy that cell: Edit>Copy
Select the range A2:A10000
Then, Edit>Paste Special>Multiply>OK
Delete the 1.05