As you work in Excel, you may find yourself collaborating with a global team. Sometimes, you may receive files with words in multiple languages. Fortunately, Excel has a handy built-in translation tool to help you understand the text inside your spreadsheets. Let’s learn how to translate in Microsoft Excel.
How to Translate in Excel
Consider a spreadsheet with text written in multiple languages. You may not recognize the words at a glance, or you may simply not have the time to do translation work manually. This is where Excel’s Translate feature comes into play. Translate is a handy Excel feature, because it does translation work for you.
To use the Translate feature in Excel, begin by clicking on a cell containing a word that you want to translate. Then, find the Review tab. The Review tab is on Excel’s ribbon, which you’ll find across the top of your screen. The ribbon includes menus like Home, Insert, Draw, and more.
Click Review, and you’ll see a plethora of options. Near the left side is the Translate button. To run the translation on the selected cell, click on Translate.
You’ll see the Translate sidebar open up on the right side of your screen. Excel’s smart features will automatically detect the language of the text inside. Or, you can click on the From dropdown to tell Excel what language to read.
Below, you can select the language to translate to by using the To dropdown. If the word you’re translating isn’t English, Excel defaults to an English translation. But once again, you can easily change these settings.
As you can see, Excel’s Translate feature is a quick and easy way to translate across multiple languages. You don’t have to use any third-party tools, saving you precious time. Try Excel’s Translate option any time you need to perform translation work in your spreadsheets.