"Find-and-replace with formatting in Excel for Mac (for example, change the text color or highlight certain words throughout a lengthy document). What I have found, however, is that apparently Excel for Mac doesn't provide this option. How is this possible? It's such a basic, fundamental function. The PC version of Excel lets you do this (of course)."
Taken from https://answers.microsoft.com/en-us/msoffice/forum/msofficeexcel-msomac-mso_o365b/excel-for-mac-find-and-replace-no-formatting/9fbc90df-e0e8-4520-a04c-fcad5abd1cc1

When having to replace similar but not identical cell content at many different places in a large spreadsheet it would sometimes be convenient if the Replace Window could be made permanently floating. Then you would be able to navigate to another part of the spreadsheet without having to close the Replace window -- while using the Find Next command in the Replace window is not a practical option -- and could then easily apply the same type of replacement in the new but slightly different cell area.

Currently : Working in two or more workbooks in separate windows share an undo history.

Idea : Workbooks should be independent and have individual edit history.

For example:

Workbook A : Data - sort - column A
Workbook B : type "hello world"
Workbook A : COMMAND+Z (undo) should undo the sort in workbook A.

Currently it undoes the type in Workbook B.

Well ... this is now february 2021 and QAT buttons are still greyed out (although functional) on version 16.35 up-to-date => what's the deal?
Was (and still is) working fine on Office 2011 (version 14. 4.5) => no can update to 64bits OS without downgrading functionalities going back over more than 10 years?

date picker for excel for Mac would be really helpful

User is unable to view the comment added in a cell, when the adjacent cell is having colour background.

when creating additional lines within a cell, the key to allow this should be SHIFT + ENTER (like in windows)

1. why drop the automatic addition of a + sign when adding cells to a formula?


2. why remove the short cuts for insert and delete? Or why make them the same as other commands? Ctrl+I and ctrl+K.

These are frustrating and unnecessary changes to the wonderful Excel UI.

When you are selecting a large range of cells with numbers formatted as strings (imported from other apps, typical situation), the icon that allows converting strings to number should appear at the end of your selection, and not at the beginning of the selection. Because as currently implemented, you need to go back to the beginning of your selection to click on the button. It does not matter with a small range of cells, but with the large range of cells, this will savea lot of time.

The handbook on the Auto-save function is very unclear.

Salve, in EXCEL 365 per MAC VBA non è possibile
attivare la FINESTRA IMMEDIATA e
attivare userform, come o quando potrete apportare eventuali modifiche o come si possono risolvere tali inconvenienti ?

I believe most people need to have the data -they are inserting - matched to the current format. This option should be set as default

Display the file name when working on the file.

There is currently no option to replace a term in your formulas for mac excel due to the lack of ability to "Look In" formulas before replacing all. Additionally, you are unable to use Find All in the find dialog box to check all mentions of a term within formulas to easily see all the times it is used

Please add the find and replace functionality as per the windows version.. I use this function to update my formulas regularily, for example to replace column B with column D within a series of formulas.