This article was previously published under Q107704
This article has been archived. It is offered "as is" and will no longer be updated.
In Microsoft Excel, only the first 100 defined names are listed inthe name box.
This 100-name limit is by design so that you can quickly define names on aworksheet from the name box. The greater the number of names listed in thename box, the longer it takes to define or display a name using the namebox.
NOTE: The names in the name box are listed in alphabetical order.
You can use any defined name by typing it directly into a formula, or byselecting it from the Paste Name list available by choosing Name from theInsert menu and choosing Paste. But, you can only select from the first 100defined names with the Names box.
The total number of defined names you can have in a workbook is limited byavailable memory. For more information about the maximum numbers ofelements you can use in a worksheet or workbook, click the Index tab inMicrosoft Excel Help, type the following text
and then double-click the selected text to go to the "Microsoft Excel forWindows 95 specifications" topic.
For more information about the name box, see pages 143-144 in the"User's Guide," version 5.0.