In cell A2 we have typed “A2” so Excel displays the value “A2” in cell A1. That means Excel output in cell A1 whatever is inputted into cell A2. Let’s refer to that earlier example – suppose in cell A1 we have a formula that simply says =A2. For example, you could anchor the row reference then move a cell down two rows and across four columns and the row reference stays the same. Mixed – This means you can choose to anchor either the row or the column when you copy or move the cell, so that one changes and the other does not. the cell reference is relative to its location. Relative – Relative referencing means that the cell address changes as you copy or move it i.e. This is done by anchoring the row and column, so it does not change when copied or moved. There are three types of cell references.Ībsolute – This means the cell reference stays the same if you copy or move the cell to any other cell. The first cell in the spreadsheet is A1, which means column A, row 1, B3 refers to the cell located on the second column, third row, and so on.įor learning purposes about cell references, we will at times write them as row, column, this is not valid notation in the spreadsheet and is simply meant to make things clearer.
0 Comments
Leave a Reply. |