Can I add percentage to every cell in a column?

C

Caitlin

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?
 
J

Joel

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).
 
T

T. Valko

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
 
Top