![]() I actually want the cell reference to change as I copy it down the column, like this:įortunately, this is what spreadsheets actually do, thanks to a feature called Relative Referencing. When copying a formula, cell addresses change relative to the cell they're written in. What I really want is the value of the cell directly across from my formula. If I did really put the formula "=A2" into all of my cells, then I would just get a column cells that all return the same thing ![]() In other words, Sheets/Excel knows that if I copy and paste my formula (=A2) into the cells below (cells C3-C7), I probably don't actually want all of these cells to point to cell A2. Most folks also know that when you copy and paste a formula that contains cell addresses, Sheets or Excel gives you the relative reference of your target cell. This isn't news to anyone except an absolute spreadsheet beginner. By extension, the formula =A2 will return whatever's sitting in your target cell: ![]() So if your target cell is in column A and Row 2, its address is A2. A cell's address consists of its column (a letter), followed by its row (a number). Most folks who use spreadsheets are used to this convention. Both Google Sheets and Microsoft Excel refer to cells by their addresses using a system called 'A1 notation'.
0 Comments
Leave a Reply. |