If you use a lot of references in your spreadsheet, naming those references can make it much easier to see what you’ve done.Įxcel also has a Name Manager that makes monitoring these names in the future easy. Click Formulas > Name Manager. In the Name Manager window, you can see a list of all of the defined names in the workbook, where they are, and what values they currently store. ![]() This is more meaningful than a cell or range address when you look back at them. In Excel, you can assign a name to a cell or range of cells. How to Use Defined Names for Simple Cross References ![]() In the following example, a SUM function is summing the values from range B2:B6 on a worksheet named Sales. Start the function as usual and then click on the sheet and the range of cells-the same way you did in the previous examples. But you might want to write a function (such as SUM) that references a range of cells on another worksheet or workbook. Referencing a single cell is useful enough. How to Cross Reference a Cell Range in a Function Keeping data in one workbook, if possible, is more reliable. ![]() Users creating or renaming folders and moving files can break these references and cause errors. Although creating references to other workbooks is straightforward, they are more susceptible to issues.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |