In our following example, we want to calculate Menu Cost(see the heading in the example) multiplying every menu’s price and quantity. We shall not create a formula for every cell, we shall create the formula for cell D4 and copy this formula to the other rows. Here we are using relative references.

### Step 1

Select the cell that will contain your formula. In our example, the cell is D4 where we shall use the formula.

### Step 2

Enter your formula to calculate the desired value in the selected cell. We shall type ‘=B4*C4’ in cell D4.

### Step 3

Now press Enter on your keyboard. The formula will be calculated internally and you will see the calculated result in cell D4.

**Read More: Relative cell references in Excel**

### Step 4

By default when you pressed Enter, the active cell is now D5. Use up arrow(↑) key to make D4 as active cell again. Now locate the fill handle in the lower-right corner of the cell D4.

### Step 5

Now click the fill handle, hold it and drag over the cells you wish to fill. We are selecting cells D5: D14 in our example.

### Step 6

Now release the mouse. The formula, we made in cell D4, will be copied to every cell we have selected with relative references. Calculated values will be visible in every cell.

**Note: **To check whether your formula is correct, just double-click on any cell from the filled cells. You will find that this formula is similar to ‘=B4*C4’ formula, except that cell references are different and dependent on row numbers. For the row number 9, the formula is ‘=B9*C9’, just the row numbers have been changed.

Relative cell references in Excel. The formula is the same, just the cell references have been changed with the row numbers.

## Download Working File

Download the working file from the link below:

New to all this. LOVE your site. Wondering if there is a way to populate cells on an alternate page, but force the population to skip down to the next row if the current row is populated?

CONTEXT

I’m researching real estate properties. Would like to run my numbers on one sheet. One the 2nd sheet, I’d like to keep a running tab of every property I’ve investigated for easy reference. So once I complete my numbers on sheet one (financials), I’d like it to populate sheet 2 (Master list) on row 1. Then the next time I run numbers on a property, those numbers populate row 2, and so on. How do I “lock” row 1 (for example) so that the next time I run numbers it doesn’t replace?