Return to site

Where is name manager in excel for mac 2011

broken image
broken image

Since the named range (FruitChoices, in our example) refers to a fixed range of cells ($H$3:$H$10 as shown), if more choices are added to the cells H11 or below, they will not show up in the dropdown (since those cells are not part of the FruitChoices range). This second method makes it easier to edit the choices in the list, but adding or removing items can be problematic.