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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |