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 Viet -MS Office Tech Your Own Question
Viet -MS Office Tech
Viet -MS Office Tech, Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 38234
Experience:  Ten years of computer hardware and software support; Windows 10 8 7 Vista XP & Mac; Microsoft Office, etc.
30037186
Type Your Microsoft Office Question Here...
Viet -MS Office Tech is online now
A new question is answered every 9 seconds

Can i increase the value of a column, which has prices, by

Customer Question

hi,
can i increase the value of a column, which has prices, by an increase percentage, instead of doing them one by one?
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Viet -MS Office Tech replied 1 year ago.

Hi,

I'm sorry about the issue. What's your Microsoft Office / Excel version, such as 2003, 2007, 2010, 2013, etc.?

Do you have windows xp, vista, or 7, or 8, 10, or mac computer?

Please reply at the box below. Thank you,

Expert:  Viet -MS Office Tech replied 1 year ago.

Please try the following:

  1. In a blank cell, put the percentage you want and add 1 to it. For example, if you want 5%, then put 1.05 in a blank cell. (Note: 1 + 5% = 1 + .05 = 1.05).
  2. Right-click on that cell, then click on option Copy.
  3. Highlight / select the column you want (or select all the cells in the column you want.)
  4. Right-click on any any highlighted cell in that column, then click on option Paste Special....
  5. Select option Multiply.
  6. Click on OK button at the bottom, then it should work.
  7. You can delete the value in the cell in step #1.

Please reply at the box below to continue. Thank you.