Seeing rates in a spreadsheet is sometimes inevitable, primarily if your data comprises numbers purely. There are times when you’ll be required to compute the percentage to show the difference in proportions. Although this could be pretty tricky, you’ll be able to achieve this by simply following the steps below.

## 2. Select the spreadsheet that you want to edit. ## 3. Enter the percentage formula into your preferred cell.

You can calculate the percentage of your data by dividing the portion by its whole. You can do this by using the “/” symbol, representing division. For this example, the proportion of the students who passed from those who took the exam will be calculated. The formula will be: Students who passed/Students who took the exam; whereas, in this case, B2/C2. ## 4. Press “Enter” on your keyboard.

To apply the formula you’ve entered, press the “Enter” key on your keyboard. You should see the answer in decimal after doing this. ## 5. Drag the formula down to apply it to the other cells.

Suppose you have multiple sets of data similar to this example. Instead of entering the formula over and over again, you could drag down the square symbol at the bottom-right corner of your formula cell. This will automatically calculate the subsequent rows, given that as you move the row of the formula cell, the data involved in the formula will follow depending on the row you’re in.

For example, if you drag down the formula to the next row, the formula will change into B3/C3, and so on. ## 6. Click on the percentage icon from the toolbar.

To apply the percentage format to your data, click on the percentage icon (%) on the toolbar above your spreadsheet. If you want to format a whole row or column, you can simply click on the row or column that you want to format before clicking the percentage icon. This will immediately format the cell or cells you’ve selected.   