the cell(s) you select and name remain unchanged unless you go into the NAME MANAGER and edit the REFERS TO information adding further rows/columns. Now tell me that’s not better than =SUM(Sheet4!B2:B5,Sheet4!D2:D5)!įinally, be aware that all the methods I have shown you here apply to FIXED dimension ranges i.e. You can now start writing formulas using as many names as necessary Test them out if you want by clicking on any of the names and see which cells are highlighted. Showing the automatically created named ranges
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |