How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask John D Your Own Question
John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

I want to increase several columns of numbers (Dollars) by

This answer was rated:

I want to increase several columns of numbers (Dollars) by 5% in Microsoft Excel for Mac 2011 version 14.2.2. How would I do this without having to multiply each Dollar amount by 5%? Is there a formula?
4 $1,895
5 $2,800
6 $3,495
7 $2,800
8 $4,375
9 $4,825
10 $4,375
11 $2,795
12 $2,395
13 $1,895



Here is how to do that


- In an empty cell type 1.05

- Copy that cell

- Select the cells that you want to apply the 5% to

- Click the Home tab > Paste > Paste Special > Multiply > OK


That should do it



For version 2011 please replace the last step with


- Click the Home tab, click the little arrow on the Paste button > Paste Special > Multiply > OK



John D and 3 other Microsoft Office Specialists are ready to help you

Related Microsoft Office Questions