![]() ![]() ![]() If cell A1 contains the number 10 but is later changed to 20, the formula that references cell A1 updates automatically. Thus, using a cell reference rather than values in a cell gives more flexibility in a worksheet.įor example, the formula =A1+A2 adds the values in cells A1 and A2. Using Excel cell references is advantageous because if the values in the referenced cells are changed, the formula result automatically updates using the new values. An Excel Cell Reference is a cell address that identifies a cell's location in the worksheet, based on its column letter and row number.įor example, A1 refers to the cell at the intersection of column A and row 1 A2 refers to the second cell in column A and row 2. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |