#Microsoft office 2019 for mac 16.47 how to#
#Microsoft office 2019 for mac 16.47 for mac#

Choose not the standard insertion method, but the one that uses the destination format styles (the second one in my case): If you have a wide table with many columns, you might better change the layout landscape, large size, and narrow borders, but I have not done so and it should be unimportant since we will not work with that Word file anyway, we do not even need to read anything of it.Ĭopy the full spreadsheet into word with a normal Ctrl+V, then hover over the pasting method that pops up directly after insertion at the right bottom or press Ctrl. Workaround: Do the translation of the Excel table in Word

#Microsoft office 2019 for mac 16.47 how to#

How to get the whole Excel spreadsheet translated using Microsoft Translator without manual work? In my case, the translation that appeared on the right could only handle eight rows (with a lot of text in them, admittedly), so that I would need to do manual work again. Yet, even if there was such an 'insert' button by some trick, the built-in Microsoft Translator cannot translate a large table. Strangely, in this Microsoft guide, you see this 'insert' button in Excel:

#Microsoft office 2019 for mac 16.47 for mac#

This is also said officially in the Microsoft Community at The Insert button in Translate is missing in Excel for Mac ver 16.47.1. Translated segments into their respective cells. Prompt this, you must click Insert or manually copy-paste the Itĭoes not automatically replace the original text in the Excel file. Keep in mind that the translation will only appear on the menu. The translator menu will appear on the right, where you can set the Then, on the toolbar, select Review > Translate. Translating Word documents and PowerPoint presentations).įirst, open your Excel spreadsheet and select the text you wish to Translations (same machine translator can be found within Word when Microsoft Excel has a built-in translator you can use for simple Instead, I would have to manually copy the translation to each cell since copying the full translation text of many rows does not keep the original spreadsheet's row structure.

Following the guide at Best Ways to Translate an Excel File - 2021 Update, clicking on the Microsoft Translator ribbon under 'Review', I could not find the 'insert' button to insert the new translation in the cells.