The Insert button in Translate is missing in Excel for Mac ver 16.47.1

Question

I have seen several posts and videos on how we can quickly translate a cell or a bunch of cells, columns in Excel.

Seems straightforward.  Except that the "Insert" button is missing from my Excel for Mac.

Steps

1. Highlight a section to translate
2. Click Review --> Translate
3. Opens a docked window on right with the From <language> and To <language> sections

 and that is it!

I am not able to "Insert" like Microsoft Help says.  That button is missing!

I do the same in Word on my Mac and here the steps are similar and I DO SEE the Insert option which replaces the selected text 

Has anyone else faced this?  Do you have a solution?

I did remove and add the Translator option to the ribbon (just had to try that out :-) ). didn't help

Thanks for your time!

Venky

Answer 1

Hi Venky Na,

I go through your post carefully and as per your description, based on to my test, I can get the same situation as you mentioned. Here are related screenshots for my test:

Mac: When I****Highlight cells Review>Translate>there is no Inset button

---

Windows: Same as Mac.

![Image](https://learn-attachment.microsoft.com/api/attachments/5b098c7a-fefb-4775-9d84-7f402ab7febd?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/37f641d9-0991-4f25-abdb-3511aad0b7a1?platform=QnA" rel="ugc nofollow">![Image](https://learn-attachment.microsoft.com/api/attachments/37f641d9-0991-4f25-abdb-3511aad0b7a1?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/a33a0a36-aa2b-4015-a981-273f30586d7c?platform=QnA" rel="ugc nofollow">

According to this Microsoft official article Translate text into a different language, in this part it notes that “In Excel, there is no Insert button, you'll have to copy/paste the text you highlighted in step1.”

By default, there’s no “Insert” button on Excel on Office 2019/365 for Mac in this case, you may refer above article in Mac version of Office. 

We feel your pain due to this limitation and we’re really feel sorry for it. To address your concern about the situation, we will be very grateful if you could take a moment to send your feedback to our development team in the UserVoice forum. Your feedback and suggestions will help us continue to improve our product's features, thanks for your time and efforts.

I appreciate your patience and understanding.

Best Regards

Waqas Muhammad

Answer 2

I have the same problem in MS excel on my non-mac laptop. How do I get insert button as per instruction videos?