![]() For performance reasons, search won't populate any results until you have entered at least two letters. The Dictionary pane enables you to search for any part of a function name by displaying all functions that contain the letters you entered. The arrow indicates the sort direction.Ĭlicking on a function name in either column brings you to the Dictionary pane, which shows the function with a short description. Just click on the language you want to sort by, and click on the name again to reverse sort. You can sort alphabetically, reverse alphabetically, and you can chose to sort on either the From or To language. If you're not sure which category a function belongs to, you can choose the All option.īy default, the functions are sorted alphabetically by the From column, in this case English, and shown here with a small down arrow next to the word English. The Reference Pane has a drop-down list for Function category, which displays all functions in each group selected with the From language on the left, and the To language on the right. Clicking the Left arrow at the top of the pane brings you back to the main pane. You can activate the Preferences pane by clicking the settings wheel at the bottom of any of the three main panes.īesides providing various links that may be of interest, you can also change your To and From languages from here at any time. The green Up arrow/Down arrow button in between To/From has been supplied to let you easily switch the From and To languages around. ![]() So if you were researching lookup functions in English, but needed the French function names then you would set the From language to English, and the To language to French. To is the language that you know, From is the language that you want to find. We are using the concept of To and From in the translator. Click Start Working when you have selected your language pair. If your install language is one of the languages we have localized for the Functions Translator, the user interface displays in the localized language. The language pair can be changed at any time through the Preferences pane, which is accessible from any of the add-in's main panes.īy default, the From and To language is pre-populated with English as the From language and the Excel Install language as the To language. Any combination of languages is possible, and Excel remembers your choice. While the Functions Translator supports all languages that Microsoft has localized Excel functions to, you can only operate with one pair at the time. Here you can configure your language set. The Language settings dialog is where you choose your default From and To languages. Select Skip to go straight to translations, or choose Get Started to go to the Language settings dialog. The Functions Translator pane opens at the right-hand side of Excel. The first time you run the Functions Translator it opens a Welcome pane: The buttons open the Reference and Translator panes in the Functions Translator dialog. When the Functions Translator is installed, it creates two buttons on the Home tab. When you find it, select the green Add button on the right to install the Function Translator add-in. Type " Functions Translator" in the upper-left search box and select Search. ![]() Select More Add-ins and choose Productivity on the left-hand side. ![]() The Functions Translator is available for free from the Microsoft Store, and can be installed by following these steps: Installing the Functions Translator add-in Has been localized for English, Danish, German, Spanish, French, Italian, Japanese, Korean, Dutch, Portuguese Brazilian, Russian, Swedish, Turkish, Chinese Traditional and Chinese Complex Script. You can give feedback on a specific function in a specific language. Provides an efficient way to search for any part of a function's name in both languages selected.ĭisplays a scrollable, and categorized list of English functions, and their corresponding localized functions.Įnables you to give feedback to Microsoft on the function translation quality. Supports all of Excel's localized languages and functions, with 80 languages, and 800 functions. The Functions Translator is geared towards people who use versions of Excel in different languages, and need help finding the right function in the right language, or even translating entire formulas from one language to another.Įnables users who know Excel's English functions to become productive in localized Excel versions.Įnables users to easily translate full formulas to their native language. This article walks you through setting up and using the Excel Functions Translator add-in. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |