So Sheet1!A1 would refer to the A1 cell on the worksheet titled "Sheet1." If you want to reference a range of cells, use a colon between the first and last cell of the range. To reference a cell on another worksheet within the same workbook, type the name of the worksheet followed by an exclamation point, then the location of the cell. To reference a cell, simply enter the location of the call as designated by its column and row for example, A1 is the cell in the top left corner of the spreadsheet. The formula can then be changed quickly by trying out different numbers in the reference cell. By entering a reference to another cell on the worksheet, you can tell the formula to work its calculation with whatever number is placed in that cell. This is where cell references come in handy. For many spreadsheets, you won't want to go back to the original formula to change all the information you're working with.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |