Can I add percentage to every cell in a column?
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? |
Can I add percentage to every cell in a column?
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? |
Can I add percentage to every cell in a column?
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? |
All times are GMT +1. The time now is 10:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com