Forum Discussion
Dublicate sheet
Hello,
How to make in excel so that when filling in information on one sheet, a copy is automatically made on another sheet, but at the same time that copy is made in another language? For example, I fill out a information in English on one sheet, and on another sheet, would they make an identical copy for me in German? I have the information translated, so perhaps the English version should be somehow linked with the German version here. Is this even possible?
1 Reply
You can use the “Copy and Paste Link” function to automatically transfer data from one Excel worksheet to another. Here are the steps:
- In sheet 1, select a cell and type Ctrl + C / Cmd + C to copy it.
- In sheet 2, right-click on the equivalent cell and go to the Paste > Link.
- To prove they’re linked, return to sheet 1 and change the value in the cell you copied.
- Finally, return to sheet 2 to see that the value has also changed.
To translate an Excel sheet into another language, you can use Microsoft Translator.
Here are the steps:
- Open your Excel spreadsheet and select the text you wish to translate.
- On the toolbar, select Review > Translate.
- The translator menu will appear on the right, where you can set the source language and the target language.
- Keep in mind that the translation will only appear on the menu.
I hope this helps!
