The more formulas you know how to use in Google Sheets, the better.
Youll need to add the cell that you want to translate.
Then youll need to add the source language, followed by the target language.
For example, if in Cell A1 you added the text: How are you?
And you want Google Sheets to translate that to Spanish.
To have the text translated, youll need to start typing =GOOGLETRANSLATE.
you could enter the cell manually, or you could punch the cell.
double-check that the commas and quotes are placed in the correct places.
like look at the image below to see where they are placed.
At the top, you should see the formula.
you could also see more information explaining the formula if you press it.
In the above formula, Google Sheets translated English to Spanish.
But lets see how it’s possible for you to make the formula auto-configurable.
Dont worry; you dont have to copy and paste the formula to every cell.
As soon as you let go, all the empty cells will be filled with the translated text.
There is another language it’s possible for you to use to identify a language.
On an empty cell, start typing =DETECTLANGUAGE.
On the cell you entered, the formula will be replaced with the initials of the language.
