Microsoft KB Archive/109157

Excel: Using the Glossary Add-In Command to Insert Data Last reviewed: September 12, 1996 Article ID: Q109157

The information in this article applies to: Microsoft Excel for Windows, version 4.0 SUMMARY In Microsoft Excel version 4.0, you can use the Glossary command on the Edit menu to enter frequently used titles, formulas, numbers, phrases, or descriptions. NOTE: The Glossary command is an add-in command. For more information about add-in commands, see pages 195-202 in the "User's Guide 2" version 4.0 MORE INFORMATION The glossary enables you to store long text or numbers and enter them by typing an abbreviation. Glossary entries ensure that descriptions or phrases are typed correctly. To use the glossary add-in command, do the following: From the Options menu, choose the Add-ins command. In the Add-In Manager dialog box, choose the Add button. In the File Open dialog box, select the GLOSSARY.XLA file from the EXCEL\LIBRARY directory and choose OK. Choose the Close button. The glossary command is now available whenever you run Microsoft Excel. To remove the glossary add-in, reopen the Add-In Manager, select the Worksheet Glossary add-in from the list, and choose the Remove button. To add entries to the glossary Type the text, formula, or number into a cell or range of cells and select all the cells that you want to be stored under a single abbreviation in the glossary. From the Edit menu, choose the Glossary command. This will display the Glossary dialog box. In the Name box, type an abbreviation that identifies this glossary entry. To add the contents of the cell or range of cells to the glossary, choose the Define button. When the dialog reappears, you can define more entries or choose the Close button. To enter an item stored in the glossary Select the cell in which you want the entry. From the Edit menu, choose the Glossary command. From the Glossary Entries list, select the abbreviation for the text you want. The first portion of the glossary entry you selected appears at the bottom of the dialog box. Choose Insert.

KBCategory: kbusage KBSubcategory: Additional reference words: 4.00 Last reviewed: September 12, 1996 © 1998 Microsoft Corporation. All rights reserved. Terms of Use.