Change Cell Values

H

Harvey Turpin

I want to select multiple cells and apply a percentage
and change the value in each sell at one time. Can this
be done? Thank you.
 
D

Debra Dalgleish

1. In a blank cell, type the percentage. For example, if you want to
increase by 20%, type 1.2
2. Copy the cell that contains the percentage
3. Select the cells that you want to change
4. Choose Edit>Paste Special
5. Select Multiply, click OK
6. Delete the percentage that you entered in step 1
 

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

Resource name inside resource sheet: per person, work per hours per week 0
Crating User Form to Add Names 1
Newbie Help - IF Yes No Function 0
Tracked changes by multiple people modified to one 0
External cell reference between two excel worksheets both in One Drive 0
Word macro that can call cells out of Excel for a find and replace 0
Conditional Formatting Amendment 2
Calculate the median value before a specified list 0

Top