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,...
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!