Can I add percentage to every cell in a column?

  • Thread starter Thread starter Caitlin
  • Start date Start date
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?
 
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).
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Decimal/Percentage to Whole Number 4
how do i increase the value of numbers in a column by a percentage 5
Conditional formatting 3
taking an average of every 30 cells 4
Formatting Percentages/LOOKUP using a Percentage 2
combining columns 4
Add percentage to a whole column of numbers 1
If statement with multiple criteria and multiple results 3

Back
Top