Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/107704

From BetaArchive Wiki
Knowledge Base

Only First 100 Names Listed in the Name Box

Article ID: 107704

Article Last Modified on 8/15/2005


  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0c
  • Microsoft Excel 5.0 Standard Edition
  • Microsoft Excel 5.0 Standard Edition

This article was previously published under Q107704


In Microsoft Excel, only the first 100 defined names are listed in the name box.

This 100-name limit is by design so that you can quickly define names on a worksheet from the name box. The greater the number of names listed in the name box, the longer it takes to define or display a name using the name box.

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 by selecting it from the Paste Name list available by choosing Name from the Insert menu and choosing Paste. But, you can only select from the first 100 defined names with the Names box.

The total number of defined names you can have in a workbook is limited by available memory. For more information about the maximum numbers of elements you can use in a worksheet or workbook, click the Index tab in Microsoft Excel Help, type the following text


and then double-click the selected text to go to the "Microsoft Excel for Windows 95 specifications" topic.

For more information about the name box, see pages 143-144 in the "User's Guide," version 5.0.

Additional query words: 5.00c XL

Keywords: KB107704