From the course: Excel 2013 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Working with relative, absolute, and mixed references

Working with relative, absolute, and mixed references - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Working with relative, absolute, and mixed references

“

In this worksheet called "Absolute", we're about to put a formula in column F. We're going to create New Salary simply by giving everybody a $2000 salary increase. Now, a formula like this involves a standard Excel technique. If I type = and click cell E3+2000, and after typing this entry, you would want to copy this down the column. If you work with Excel formulas a bit, you know Excel will do exactly the right thing here. In other words, if we complete the formula and drag from the lower right-hand corner--let's just check it out on a few cells-- Excel is not using E3 over and over and over again. It's surely adjusting to using E4 and as I double-click on these, E5 and E6 and so on, for as far down as we might copy this. That's called a Relative Reference. It's the most common kind of reference in Excel--a cell reference that is relative. If we copy the formula into different rows, it adjusts the Row Reference of a formula. Let's take a different situation here where we want…

Contents