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?

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

"Caitlin" wrote:

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?

Enter 1.3 in an empty cell
Copy that cell: EditCopy
Select the range of cells that you want to increase
Now do: EditPaste SpecialMultiplyOK
Delete the 1.3

--
Biff
Microsoft Excel MVP


"Caitlin" wrote in message
...
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?