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:

  1. From the Options menu, choose the Add-ins command.

  2. In the Add-In Manager dialog box, choose the Add button.

  3. In the File Open dialog box, select the GLOSSARY.XLA file from the EXCEL\LIBRARY directory and choose OK.

  4. 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

  1. 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.

  2. From the Edit menu, choose the Glossary command. This will display the Glossary dialog box.

  3. In the Name box, type an abbreviation that identifies this glossary entry.

  4. To add the contents of the cell or range of cells to the glossary, choose the Define button.

  5. When the dialog reappears, you can define more entries or choose the Close button.

To enter an item stored in the glossary

  1. Select the cell in which you want the entry. From the Edit menu, choose the Glossary command.

  2. 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.

  3. Choose Insert.


KBCategory: kbusage
KBSubcategory:

Additional reference words: 4.00



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.