Meraz Al Nahian
The article will show you how to translate Portuguese to English in Excel. There may be a lot of ways to translate any language to English, but if you use Excel and don’t want to change the browser or application, you can do this which will save time. The features of Excel to translate Portuguese to English are efficient.
Download Practice Workbook
4 Efficient Ways to Translate Portuguese to English in Excel
In the dataset, you will see some Portuguese words and sentences. We’ll translate them in the following sections of this article.
1. Using Translate Command
The easiest way to translate Portuguese or any language to English is to use the Translate command from the Review Tab. Let’s have a look at the simple explanation below.
Steps:
- First, select the cell which you want to translate.
- After that, go to Review >> Translate.
- Next, you will see the translation of this word to English in the Translator
- Thereafter, if you want to see the translation of all the Portuguese words in the dataset, just select the range. The Translator window will be updated with the translations of new words and sentences.
- In addition, if you want to see the synonyms, you can find them by simply putting the cursor on the corresponding words. Here, you will see the synonyms of the word ‘becomes’ both in English and Portuguese.
Thus you can easily translate Portuguese to English. You can apply this method to any other language too. Excel will automatically detect the language and then translate it into English after the command is applied.
Read More: How to Translate Excel File to English (2 Easy Ways)
2. Applying Translator Add-in to Translate Portuguese to English
There are some Add-ins in the Microsoft Excel store which you can download and use to translate Portuguese to English. The following description will help you to understand the process.
Steps:
- First, select Insert >> Add-ins >> Get Add-ins.
- After that, search for ‘translator’ in the Office Add-ins There are some Translator Add-ins in the store, but I found that the SYSTRAN is the better choice.
- Next, the SYSTRAN Add-in will appear in the Home Tab. Select it.
- This operation will open the SYSTRAN window to get you started.
- After that, you need to Sign Up on this website.
- Clicking on the Sign-Up option will take you to the SYSTRAN browser and you should provide the necessary information there. Also, you should check your Email to set up the password.
- Thereafter, go back to the Excel sheet and click on Connect.
- Next, a confirmation request from the SYSTRAN website will appear. Just select Continue.
- Later, you will see the Sign In confirmation.
- Again, go back to your Excel sheet. Close the connection window.
- After that, you can see that there are two options in the SYSTRAN. You can either translate a content from a cell or you can translate the whole workbook.
- Let’s just select the cell C5. The translation of this word will automatically appear.
- In addition, you can replace this Portuguese word with it’s English translation by clicking on Replace Selection.
The cell C5 is now automatically replaced by it’s English form.
If you select the Translate full workbook option, it will create a new workbook and you will see all the Portuguese words in the previous workbook become English.
Thus you can translate Portuguese to English by using an Excel Add-in. This is a faster process when the workbook contains a lot of non-English word.
3. Copying Excel Cell to Google Translate
This method is also pretty simple. Let’s go through it.
Steps:
- Simply copy the word from the Excel sheet and paste it to the Google Translate Google will automatically detect the language and
Thus you can translate Excel cells with Portuguese words or sentences using Google Translator.
Read More: How to Translate an Excel File from Japanese to English
4. Translating Excel Functions
Excel has options for the users of different countries to type the functions in their own format. Say, you have a business relationship with a Portuguese individual and he/she provided you with an Excel file full of formulas written in Portuguese. Don’t worry, please follow the instructions below to understand how to translate the functions.
Steps:
- First, add the Functions Translator Add-in from the Office Add-ins
- After that, this Add-in will be added to the Home Tab.
- Next, select Home >> Functions Translator >> Translate. See that there are some functions written in the Portuguese format in the sheet.
- In the Functions Translator pane, we need to set up the Settings. Select it first.
- Next, set up the Preferences. Select Portuguese to English translation set up.
- Next, copy the function name and paste it in the window.
- After that, click on the Down Arrow This will show you the function name in English.
Thus you can translate Excel functions in Portuguese format to English. But this Add-in has limitations, it can’t translate every function. Hopefully, the developers will update this Add-in so that any functions can be translated to English in future.
Read More: How to Translate Language in Excel Formula (with Easy Steps)
How to Translate Any Language to English in Excel
All the methods stated above can be used to translate any language to English. The first method, where we used the Translate command is very much useful if you want to translate a word instantly. Using Add-ins is time costly, so applying them is beneficial when we need to translate a huge amount of non-English words or sentences.
Practice Section
Here, I’m giving you the dataset of this article so that you can practice these methods on your own and gain expertise.
Conclusion
In the end, we can consider that you will learn efficient ways of how to translate Portuguese to English in Excel after reading this article. If you have any better suggestions or questions or feedback regarding this article, please share them in the comment box. This will help me enrich my upcoming articles. For more queries, kindly visit our website ExcelDemy.
