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