Thread: Can I add percentage to every cell in a column?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
  
Posts: 9,101
Default 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?
Reply With QuoteReply With Quote