Pin Me

Microsoft Excel: Increase A Range By Two Percent

written by: Mr Excel•edited by: Tricia Goss•updated: 7/23/2008

Problem: You run the repair department for a company. As shown in Fig. 779, you have a spreadsheet of prices. Your manager tells you to increase the price on all service contracts by two percent.

  • slide 1 of 2

    See all Microsoft Excel tips


    In a blank cell, enter 102%, as shown in Fig. 780. Copy that cell and then use Paste Special Multiply to multiply all of the contract prices by this cell.

    1) Find a blank cell, such as D1. Enter 102% in that cell.

    2) Select D2 and choose Edit – Copy from the menu.

    3) Select all of the rates in column B.

    4) From the menu, select Edit – Paste Special. In the Paste Special dialog, choose Values and Multiply, as shown in Fig. 781.


    All of the values in column B are increased by 2 percent, as shown in Fig. 782.


    Multiply an entire range by a single cell, using Paste Special – Multiply.

    Commands Discussed:

    Edit – Paste Special – Multiply



    See all Microsoft Excel tips


  • slide 2 of 2


    Fig. 779Fig. 780Fig. 781Fig. 782