Dynamic named range, based on a formula.To avoid the problem of missing items with static lists, use dynamic lists instead. ![]() Click the check mark, to complete the change, then close the Name Manager.In the Refers To box, change the address, to include the new items.On the Excel Ribbon's Formulas tab, click Name Manger. ![]() Instead of an address, you might see a name in the Source box, such as:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |