Translate in Excel (Table of Contents)
Translate in Excel
The common language we used in excel is English and all the content, words everything will be English language. We all know English is the universal communication language in today’s modern world. In 99.99% of the cases, we all use the English language to present our data.
However we can change the content of the default English language to our own language, it could be a single word, it could be a full sentence or it could be a paragraph as well. We can convert it to 51 available languages in excel.
Where is the Translator in Excel?
You must where exactly the translator function in excel. You must be thinking it could have been hidden like Data Analysis Toolpak, or any other built-in options in excel. If you are thinking it is a hidden gem in excel you are wrong because it is not a hidden gem in excel rather it is available up front under the REVIEW tab in excel.
Yes, you are correct this option is gone unnoticed because of the not exact requirement in our day to day work. We learn only what is necessary for us apart from that we will not even bother about learning other things which add values to our career. But we will overcome that today and learn the unnoticed option called Excel Translator.
Convert Words to Other Languages
Let’s start something new by starting converting words to other languages. Follow the below steps to convert the words into other languages.
Step 1: Go to REVIEW Tab and click on Translate.
Step 2: Now we will see below option on the right-hand side.
Step 3: In the Search for: type the word you want to covert.
Step 4: Select the From & To language.
Step 5: Now click on ok to complete the process. It will Show the result of this word in Hindi.
Step 6: If you click on Insert it will insert the converted text to the active cell in the worksheet.
Install Excel Function Translator Add-In
If you not a regular of English language then it is quite difficult to understand the functions in excel. In order to overcome this barrier, we can install the free excel function translator add-in to the excel. Note: I am using Excel 2013 version.
This Excel add-in can convert 800 different functions into 80 different languages. Add-in can convert the function to 15 different languages and common languages are English, Danish, German, Spanish, French, Italian, etc.…
Follow the below steps to install the Excel Functions Translator. You need an internet connection to install the add-in.
Step 1: Go to INSERT tab and click on Store.
Step 2: Now you will see Online Browser option.
Step 3: Now in Search field type Excel Function Translator and search. You will see this add-in.
Step 4: Now click on Add it will add the add-in to your excel. Before that, you need to do some installation process. You will see on Function Translator installation wizard on the right-hand side.
Step 5: Scroll down and select Get Started. Here you need to select converting language. I have selected English to Danish.
Click on Start Working.
Step 6: Go to the Translator and enter the formula you want to convert.
Step 7: Now click on the down arrow key to covert.
Step 8: Now it will convert the formula to the selected language.
Things to Remember About Translate in Excel
- Once the excel translator is installed it is available under the INSERT button and Under My Apps.
- You can select any language available under usage language section.
- We can sort all the formulas from A to Z under toggle sorting.
- Once the language is selected we can see the formula name in other languages as well as the English language.
- Under the dictionary, we can search for the function that we want.
- You need an internet connection to work with these excel function translator.
- There are 51 languages available in excel and you can convert the function to any of them with the description in the selected language
This is a guide to Translate into Excel. Here we also discuss where is the Translator in Excel along with practical examples. You can also go through our other suggested articles –