Settings in Excel – dictionary
New dictionary
Language
Here you can determine the languages which, when a new dictionary is created, will be allocated to the respective columns in the dictionary. To do this, simply enter the desired language in the corresponding field.
Visible language
If you use fewer than five languages in your Excel file, hiding the unused columns will make the file appear more organized. Simply select the number of visible languages.
 |
Good to know
|
|---|---|
To change the names of the languages later on, or to reduce the number of languages shown, on the “*Translation” ribbon in the “Dictionary” group, under “Translation Manager”, click on the drop-down menu and select “Configuration”. |
Update
Update sub-dictionary when saving
The sub-dictionary will be automatically updated when it is saved.
Also update hits when updating the dictionary
If the name of a worksheet is changed in the course of the project, the names of the hyperlinks that refer to hit(s) will have to be adjusted accordingly. This is done automatically during updates if the “Review and update hits” setting is activated.
For very large workbooks, the dictionary updates can be accelerated by deactivating the “Review and update hits” function. In this case, you can manually update the adjustment of the hyperlinks by clicking “Update” in the “Hits” group.
Edit terms
Check for requested terms before opening the translation manager
This function ensures that no requested terms are missed. Each time you enter the translation manager, it is checked for requested terms. If there are requested terms, the “Requested terms” dialog opens automatically.
Sorting
Move crossed-out terms to the bottom
If a dictionary term is not used in any sheet and thus does not have any more hits in the dictionary, it is displayed as crossed-out in the main language.
If this has been ticked, the unused terms will be moved to the end of the dictionary when sorting a language.
See also
The translation manager
Settings in Excel
Settings in Excel – transmitter values
Settings in Excel – read version