EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tips Excel Translate
 

Excel Translate

Madhuri Thakur
Article byMadhuri Thakur

Updated July 3, 2023

Excel Translate

 

 

Introduction to Excel Translate Function

Excel Translate is a powerful in-built function to convert any word or sentence into several languages. This tool is ideal for professionals working across different native languages.

Moreover, it facilitates effective communication by sharing documents with colleagues and business partners in multiple languages, enhancing readability and preventing confusion.

Where is the Translator in Excel?

In Excel, the “Translate” feature is available under the “Language” section of the “REVIEW.”

Translate In Excel

How to Translate in Excel?

Let us learn how to translate words and sentences from one language to another with the help of the following examples.

You can download this Translate Excel Template here – Translate Excel Template

Example #1

How to Convert Word to Other Language? 
In the example below, you will learn how to translate a word from English to Hindi.
Step 1: Go to the”REVIE” tab and click” Translat”. A”Translato” Window will open on the right side of the screen, as shown below.

Translate in Excel-Example 1 step 1

Step 2: Type the word you want to convert and select the”Fro” and“T” languages from the options. For example, type Today and select English in From and Hindi in the To section. The result will display automatically.

Eg 1 Step 2

Note: The Swap option of the translator function can be used to interchange the To and From languages.

Translate in Excel-Eg 1 Step 2-2

Note: You also directly select the cell you want to translate. The selected text will display automatically in the upper box. Then you have to choose the target language. Text is immediately translated into the target language, as shown below.

Eg 1 Step 2-3

Example #2

How to Translate Multiple Cells in Excel?
You can also select a range of cells you want to translate.
Suppose you have the below data of some words in English, and you want to translate those words into another language like Chinese and French.

Translate in Excel-Eg2

Solution:
Step 1: Follow step 1 from the above example 1.
Step 2: Select the range of the cells of column A and copy in the From section of the Translator pane.
Step 3: Select the language in the To. Here, we have selected German.
The result will be displayed in the menu as shown below.

Eg2 Step 3-1

Note: Remember that the translated words will only appear on the menu. You have to copy-paste the translated word into their respective cells.

Eg2 Step 3-2

Step 4: Repeat the same procedure for Chinese and French.

Translate in Excel-Eg2 step 4

All the words are now translated into different languages, as shown above.

Example #3

You can also change a long sentence from one language to another. For example, there is a long sentence in English -“Hello, my name is David. I love cooking and listening to music. “You want to translate this sentence into French.

  • Type the above sentence in the From section and select French in To. The output is shown in the image below.

Eg3

How to Install Functions Translator Add-Ins

Microsoft Excel has a feature of Functions Translator, which needs to be installed for practical use. The Functions translator allows users to translate all Excel formulas to their native language easily. This translator can be easily installed from Microsoft Store and is free.
Follow the below procedure to install the Functions translator in Excel.

Step 1: Open Microsoft Excel.
Step 2: Go to Insert table, and select Get Add-ins from the Add-ins section.
Step 3: An Office Add-ins Window will pop up. Search for Functions translator in the upper-left search section.
Step 4: You will see Functions Translator at the top; click Add, as shown in the image below.

How to install Functions Translator step4-1

How to install Functions Translator step4-2

Step 5: Click on Continue to accept the terms and policy of Excel, as shown below.

How to install Functions Translator step 5-1

  • The Function Translator is installed successfully. It will appear at the bottom, as shown below.

How to install Functions Translator step 5-2

  • The function Translator will appear in the Home tab. It will have two options: Reference and Translator.

How to install Functions Translator step 5-3

Step 6: Click on the translator, and a welcome pane will open on the right side of Excel.
Step 7: Click on Get Started.

Translate in Excel-How to install Functions Translator step7

  • A language settings dialog will open. This dialog box allows you to select From and To

Step 8: Select From and To languages.

To is the language you know and are familiar with, and From is the language you want to find or translate. Note: You can change the language anytime through the Preferences pane. The swipe button, represented in an up-down arrow, allows you to switch the language easily.

For example, if you know French and want to translate Excel formulas into English. You can select English in the From and French in the To, as shown below.

How to install Functions Translator step 8

Step 9: After selecting the languages, click on Start Working. A translator pane will open.
Step 10: Enter the formula you want to translate.

For instance, you have the below data on fruits and their quantity. Here, you want to translate the sum formula from English to French. You must enter the formula in the From box and then click on the green down arrow. The formula is translated into French, as shown below.

Translate in Excel-How to install Functions Translator step 10

Things to Remember

  • The shortcut to open the translate window is Alt + Shift + F7Excel’s’s translator result may be prone to errors and inconsistenciesExcel’s translator is mainly suitable for personal understanding.
  • The translated text or sentence may not be ideal for professional use.
  • You should have an internet connection to access the Excel function translator.
  • You can search for the Excel function under the dictionary of Function Translator.

Recommended Articles

This article is a guide to Translate in Excel. Here we learn to translate text to different languages using Translate in Excel and how to add a translate option in Quick Access ToolBar. You can also go through our other suggested articles –

  1. Mixed Reference in Excel
  2. Spelling Check-in Excel
  3. Excel Quick Access Toolbar
  4. Excel Toolbar

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Translate Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Translate Excel Template

EDUCBA

डाउनलोड Translate Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW