OmniDocWhere is the translation function in Excel? How to use and how to set up
It explains the common entrances to Excel's built-in translation function, how to use it, how to turn off or adjust the recommended prompts, and gives alternative methods for translating the entire table to help you decide which method to use.
Key points of this article
- Most of the translations that come with Excel are translations of single cells or selected text. The entry and name vary with the version, subscription and region. If you cannot find it, check the version first and then search for "translate".
- The TRANSLATE function will write the result as a formula. Before overwriting the original text, you must first copy and then selectively paste it as a numerical value to avoid losing the original content.
- For entire tables, multiple worksheets, or formatted files, cell-level translation is inefficient and is suitable for uploading to a specialized document translation tool as a whole.
- Translation results require manual verification, especially professional terms, product names and numerical units.
Many people open Excel and want to change a column of English product names, a paragraph of remarks, or the description of the entire table into Chinese. Their subconscious question is "Where is the translation function of Excel?" This question seems simple, but actually we need to distinguish two things: what translation portals are built into Excel itself, and how to open, close and adjust these portals. They are not the same question as "which external tool to use?"
This article is written for people who need to process a small amount of text translation in Excel but are not sure where the function is. After reading this, you will be able to determine whether your Excel supports translation, find and use the corresponding entry, know how to turn off unnecessary recommendation prompts, and understand what to pay attention to when overwriting the original text and batch processing.
Where is the translation function in Excel? One sentence conclusion
Excel's built-in translation is mainly for cell text and formulas. The entry location and name will vary with the version and subscription status. A safe approach is to confirm the version first, and then search for "translate" in the software; if it is an entire table, it is recommended to use a document translation tool instead.
| your situation | Recommended practices | reason |
|---|---|---|
| Translate only a few cells | Process them one by one using the translation command or the TRANSLATE function | Less operations required, results can be verified directly |
| Translate command not found | Check your Excel version and login status, then search for "translate" | Some features are only available in the subscription version or in specific regions |
| Want to keep the original text and translation side by side | Add a new column next to it for the translation | Convenient for comparison and avoid overwriting by mistake |
| The entire table or multiple worksheets need to be translated | Upload to the document translation tool, choose bilingual or translation only | It is easy to miss items when processing cell by cell, and it is difficult to retain the format. |
| A translation or recommendation prompt pops up and I want to turn it off. | Find settings related to smart services, suggestions in the options | Tips come from optional smart features that can be turned off on demand |
What are the common Excel translation entries?
The functions related to "translation" in Excel are roughly divided into three categories. They operate in different ways, and it is easy to find mistakes when mixed together.
Translation command after selected text
In newer subscription spreadsheet software, there is usually a translation command in the review-related group of the ribbon. After selecting one or more cells and performing translation, the software will open a side pane or pop-up panel to display the translation, and you can choose to insert or copy. This type of operation is suitable for temporarily translating a small amount of text, and the result will not automatically replace the original text.
TRANSLATE function
Newer versions support the TRANSLATE function, which allows you to translate quoted text into the target language by entering a formula in a cell. The basic form of the function is "text to be translated, source language code, target language code". The language code is for example en for English and zh-Hans for simplified Chinese. Its result is the formula output, and the text will be updated as the source cell changes.
Recommended tips
Some versions will give you translation or smart fill-related suggestions when you type or paste foreign content. Such prompts are optional intelligent services and are not independent translation form tools. If you find it disturbing, you can look for switches related to smart services, suggestions or experimental features in the software options. After turning it off, the prompts usually no longer appear.
Note: The menu names, locations and available functions of different versions vary greatly, and this article does not list the specific paths one by one. If you cannot find it, refer to the Excel interface you opened.
How to find and use the translation function of Excel
Here are general steps that don't rely on specific menu names and will apply to most newer subscription versions:
- Enter the account or version information page of the software and confirm that you have logged in and that it is a newer version.
- Check whether there are review, proofreading or language-related groups in the ribbon and find the translation command.
- If it is not in the ribbon, use the search box at the top of the software to enter "translate" to see if related commands appear.
- After finding it, first test in the blank column: select an English cell, perform translation, and check whether the translation is correct.
- If you want to use formulas in batches, enter the TRANSLATE function in a blank column, reference the original text cell, fill in the language code, and then fill down.
How to set, close or directly overwrite the original text
Setting up and covering the original text is a problem-prone link, and it is suggested to deal with it according to the following ideas.
- Turn off recommendation tips: Open the software options, look for settings related to smart services, suggestions, and experience, and uncheck the corresponding boxes. Different versions have different locations. After making changes, close and reopen Excel to check.
- Back up before overwriting the original text: Save the original table as a copy, and then perform the translation operation. Avoid being unable to restore after direct overwriting.
- Convert the formula result into fixed text: The result of the TRANSLATE function is a formula. After confirming that the translation is correct, copy this column and use Paste Special to paste only the values. The original text can then be deleted or replaced.
- Direct overwriting method: For a small number of cells, you can manually enter the translation after reading it; for the entire column, first generate the translation in the adjacent column, check it, and then paste it as a numerical overlay.
# Common misunderstandings and easy to confuse
Myth 1: Excel translation automatically preserves all formatting. Cell-level translation mainly replaces text, and merged cells, comments, charts, data validation and other contents may not remain unchanged. Check whether the format is affected before overwriting.
- * misunderstanding 2: function translation and translation pane are the same thing. **
The pane translation is an one-time operation, and the result does not change with the original text; the TRANSLATE function is a formula, and the translation will change together after the original text is modified. The two are suitable for different scenarios.
- * misunderstanding 3: the results of machine translation can be used directly. **
The translation of Excel comes from machine translation, and product names, models, technical terms and numerical units are prone to errors. When contracts, financial or formal reports are involved, they should be checked item by item.
# Core comparison
| Mode | Suitable for the scene | What you need to pay attention to. |
|---|---|---|
| Translate a command or pane | Temporarily translate a small amount of text and confirm it one by one | The results will not be updated automatically and need to be inserted manually |
| TRANSLATE function | A list of texts needs to be translated uniformly, and the original text may change. | Depending on the version and language code, the formula needs to be filled down |
| Recommendation hint | Refer to it occasionally and take a look at it as you enter it. | It is an optional function and can be turned off. It is not suitable for formal translation. |
| Document translation tool | Entire table, multiple worksheets, or need to keep typesetting | If you need to upload files, you should pay attention to file confidentiality and data security. |
# how to use it in practice: translation of the whole form
When the table has many contents and complex structure, the cell-level translation efficiency is low and it is easy to leave out items. You can hand over the entire Excel file to OmniDoc for processing, as follows:
- Open omnidoc.top in your browser and upload the Excel file you want to translate.
two. Choose the output mode: bilingual control, or only output translation.
- Wait for the processing to complete, download the results, open it and check the header, numbers and technical terms.
If you need to process it locally, you can also use a desktop client at the download address of download.omnidoc.top. This paper does not make a specific commitment to the processing speed or accuracy, and the important contents still need to be manually reviewed.
# which method is suitable for you?
-if there are only a few cells, just use the translation command or TRANSLATE function that comes with Excel. -if you need to maintain a list of translations for a long time, and the original text will be updated, it is suitable to use the TRANSLATE function and save the final result as a numerical value. -if it is a whole form, requires retaining the format, or wants to deliver a bilingual version at the same time, it is recommended to use a document translation tool to deal with it as a whole.
# frequently asked questions (FAQ)
1. Does Excel have a translation feature?
Yes, but the features available in different versions and subscription states are different. Newer subscription versions usually support translation commands and TRANSLATE functions. Older versions may not have them, so you need to confirm your own version first.
2. Can Excel translate English automatically?
You can use the TRANSLATE function to let the cell automatically output the translation with the original text, but this requires manually entering the formula and filling it down, instead of automatically translating the whole table when you open the file.
3. How to disable excel translation?
The translation command itself does not need to be closed, just do not click when it is not in use. If it is a recommendation prompt that pops up when entering, you can find the relevant smart services or suggested settings in the software options, uncheck the box and restart the software.
4. How to directly overwrite the original text in excel translation?
It is recommended to back up the original table first, and then paste the translation as a numerical value to overwrite the original cell. Directly overwriting the result of the formula will lead to the loss of the reference relationship, which should be converted to numerical value before operation.
5. Where is the batch of excel translation?
Excel does not have a unified entry for batch translation. Batch processing is usually done by filling in formulas or uploading files as a whole to a document translation tool.
# Summary
The translation functions of Excel are mainly cell-level commands, TRANSLATE functions and optional recommendation prompts. The entry varies with the version. If you can't find it, confirm the version before searching. Be sure to back up before overwriting the original text and check the terms and numbers in the translation. A whole form or a document that needs to be kept in format is more suitable for document translation tool processing.
