Relative and absolute referencing


show more Relative and absolute referencing provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Relative and absolute referencing

We're going to learn about relative and absolute referencing by using the StoreA worksheet. So you can open that now. Before we learn about referencing, I want to review the concept of a cell addresses. And what a cell address is, is the identifier that distinguishes this particular cell here, G2, then any other cell in the whole spreadsheet. The cell address denotes the column that it's in and the row that it's sitting in. So, it's G2 is this cell here. The name of that cell is over here in the name box. So that's that cell address that I'm looking at.

Now when you use cell addresses and formulas, it gives you a lot of power. If I use my arrow keys and move over to cell E2, you'll see that this particular formula was created using cell addresses. I'm seeing D2*C2. Now as a little review, you'll know that this is a formula because it starts with an equals sign and it's using a operator. In this case it's the multiplication operator that is the as...

Relative and absolute referencing
Video duration: 4m 54s 5h 13m Beginner

Viewers:

Relative and absolute referencing provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...