Can I add percentage to every cell in a column?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Caitlin - 28 Apr 2008 06:08 GMT

I need to add 30% to a whole column of prices, Is there any way that I can do
that besides going in and changing every number?

Reply to this Message

Joel - 28 Apr 2008 06:33 GMT

copy the data from one cell. Then click on frost destination cell. Hold
down Shift-Cntl and press down arrow. This should highlight all the data.
Then paste the new value using the menu Edit - Paste (or press Cntl - V).

> I need to add 30% to a whole column of prices, Is there any way that I can do
> that besides going in and changing every number?

Reply to this Message

T. Valko - 28 Apr 2008 06:46 GMT

Enter 1.3 in an empty cell
Copy that cell: Edit>Copy
Select the range of cells that you want to increase
Now do: Edit>Paste Special>Multiply>OK
Delete the 1.3

Signature

Biff
Microsoft Excel MVP

>I need to add 30% to a whole column of prices, Is there any way that I can
>do
> that besides going in and changing every number?

Reply to this Message