Let’s take a look at the following dataset in which we have the costs of different items and we wish to calculate the percent discount on each of them.

We have already implemented the formula to calculate the discounted price in the above dataset and calculated the first value. Now if we drag the formula across all cells starting from **B4 **to all the way to **G4, **we will not get the desired results because all the cells above these cells are empty. Let’s see how we can use **CTRL+R **to solve this problem.

Excel is a very powerful tool to perform mathematical and statistical calculations on numeric data. It also provides a variety of tools and shortcut keys to perform functions quickly. In today’s tutorial we’ll learn how to use the shortcut key **CTRL+R **in Excel.

### Step 1 – Use **CTRL+R **to fill data across all cells

– The data shows we have already calculated the discount on the first item and we wish to use the same percent discount for each item. In this scenario the shortcut key **CTRL+R** comes in very handy. We’ll select the first cell from **B3** and extend our selection up to** G3 **and then press **CTRL+R. **This will fill all cells with **15% **and the discounted price will be calculated automatically because the formula was already in place.