A super simple guide on how to translate text in Google Sheets.

The article below will guide you on how to translate vocabulary on Google Sheets simply and in a very short time.

A great trick for office workers is to translate text directly in Google Sheets. Here's how to translate text in Google Sheets.

Step 1:

Open the document that needs to be translated.

Step 2: Click on the cell where you want to display the translation result. For example, in the image below, the cell containing the content to be translated is A2, and the cell where you want the translation result is B2.

Step 3: Enter the command =GOOGLETRANSLATE(A2;"en";"vi") in that cell. Where:

A2: Contains the content you want to translate.

en: Language code to be translated (e.g., The image above is English with the word "en").

vi: Language code after translation (e.g., If you want to translate to Vietnamese, use the phrase "vi").

Additionally, you can find code for many other languages ​​in the Wikipedia information.

Step 4: Press Enter to complete the translation.

Step 5: Drag and drop the mouse to fill all the remaining cells.

Please note that the translation results may not be 100% accurate; you need to double-check after the translation function has completed its task.

Source: https://baoquocte.vn/huong-dan-cach-dich-van-ban-trong-google-sheet-sieu-don-gian-243992.html