Useful when referencing a range of cells relative to a given cell's This method is less common than A1 notation, but can be However, if there’s a named range titled "Sheet1", then Sheet1 refers to the named range and 'Sheet1' refers to the sheet. Similarly, Sheet1 refers to all the cells in Sheet1. For example, A1 refers to the cell A1 in the first visible sheet, whereas 'A1' refers to all the cells in a sheet named A1. Tip: Where possible, use distinct names for the objects within your spreadsheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |