Simply select the cells to format and then click the Percent Style button in the Number group on the ribbons Home tab. Input the original number for example into cell A1. The CtrlD shortcut fills data down or to the right through all selected cells.
Although theres no basic percentage formula in Excel you can multiply a number by a percentage using a formula.
Select all of the cells of the Percentage of Change column and then press CtrlD. Apply the formula to other cells to get the result. Excel formula for percentage change percentage increase decrease To calculate percent change between values A and B use the following formula. Increase a number by a specified percentage this can be done by simply multiply the number by 1 the percentage increase.