"Excel Relative Cell Reference (Example Demonstration)"
Follow the example closely to understand how the Excel relative cell reference work. This step-by-step example explains the relative cell reference in details.
Create a worksheet as shown below:
In the figure above, we can see a formula sitting in cell D2. This formula will be copied down the column so that we can avoid having to create six separate formulas. That formula is using the cell reference B2.
However, from the point of view of the formula, the formula does not see a B2 cell reference, but instead it sees the relative position "two cells to the left of whatever cell the formula is sitting in (housed in)".
Similarly, the cell reference C2, is not really C2, it is "one cell to the left of whatever cell the formula is sitting in (housed in)". Even though you see the cell reference B2 with our eyes, that is not what the formula sees.
Now, let's prove that when you copy the formula down, the formula does not really see "B2 minus C2", but instead it sees "Two cells to the left minus one cell to the left".
The formula in cell D3 does not have a B2 or a C2 cell reference. When we copied the formula down, the row reference 2 changed to 3. We can see with our eyes that "=B2-C2" changes to "=B3-C3".
This further proves that the original formula was not "B2 minus C2" because if it were, when we copied it down, it would still say "B2 minus C2".
If you are to become great with formulas, you must read formula just as Excel reads them. The formula "=B3-C3" that sits in cell D3 is read as; "two cells to the left minus one cell to the left. Now let's copy the formula down the whole column.
In the figure above, we can see with our eyes the formula "=B7-C7", but we know that because these are Relative Cell References and we are copying the formula, the proper way to read this formula is "two cells to the left minus one cell to the left.
Recommended Resources:Click on the image to view the details of the training/book.
Microsoft Excel 2010 Formulas
The Ultimate Guide to
The Ultimate Guide to
Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?
| Home | Excel 2007 Tutorials | Word 2007 Tutorials | PowerPoint 2007 Tutorials | Outlook 2007 Tutorials |
| Free Templates | Free Clip Arts | Free Tips & Tricks | Free Keyboard Shortcuts | Office 2003 Books |
| Excel 2003 Tutorials | Word 2003 Tutorials | PowerPoint 2003 Tutorials | Outlook 2003 Tutorials |
| Office 2010 Tutorials | Excel 2010 Tutorials | Word 2010 Tutorials | PowerPoint 2010 Tutorials |