Select the cell in which you entered 10. To show a number as a percent in Excel you need to apply the Percentage format to the cells. To calculate the percentage of a number you just have to insert a number and apply the percentage.
The CtrlD shortcut fills data down or to the right through all selected cells.
How to calculate percentage in Excel Select an empty cell where you want the answer displayed. To calculate the percentage of a number you just have to insert a number and apply the percentage. To calculate the percent change in excel we need at least two numbers from different time periods. Type the following formula into any Excel cell.