Enable Shape Format --Shape Outline options for embedded Word documents on spreadsheet that appear as objects. In past versions of Excel, you could remove the black line in formatting so that text appeared on the sheet without a border. Haven't been able to turn in reports for over a year in newer version. Only works with the text box which defeats the purpose of being about to Word functions such as grammar, etc. inside Excel.

Paste values with "command+shift+v" to paste only values and not the formulas.

Now "command+shift+v" doesn't do anything.

If you right click on a cell you can only add the hyperlink to that cell but you cannot copy the hyperlink TO that cell. This could be very useful when you have long sheets and want to jump to a specific section. You can just copy the link to that section cell and paste it in the hyperlink of an index at the top.

There is a problem when using data validation with freeze panes.
The dropdown arrow does not display on frozen panes, but does on the unfrozen element. See attached example.
I am using Excel for Mac v16.20 (181208)

Currently when I import data from a CSV file, Excel doesn't recognise that it is CSV even though the file name ends in ".csv"! I have to tell the program that the data file has delimited fields and define the separator as comma for it to import the data correctly. Surely this is basic stuff for a program like Excel?

Definitely need a way to enter the static date and time on the iPad in excel. There is no command or control button on the iPad keyboard

allow mac users to add equation symbols to quick access toolbar (equal, -,+,/,*,(,),: ) . Same as window users.

Lots of posts, but when a new user signs up and reads previous posts, they're not dated. Many of them ask for specific fixes or optimizations or places where parity with the Windows product is needed, and many of those threads contain "we're working on it," but the thread posts aren't dated.

It was Microsoft who developed the UserForm capability in VBA for Excel and now it is gone - what do people do now.

Allow full control of chart titles. I need to be able to left align text and resize chart title boxes (Office for Mac 2016). Right now, I have to replace chart title boxes with text boxes, and then I have extra steps to take to copy over these text boxes when I paste the chart into PowerPoint or Word.

It would be great if, as for the Windows version, the Mac version of Excel enables Screen Updating when running a VBA macro. Currently, starting a macro runs but there is no indication whether the application is indeed calculating or simply frozen. adding the command Application.ScreenUpdating = TRUE has no effect

Where has the Name Manager for Mac (Excel 2016) gone? I have imported work done earlier on a Windows platform and now need to work with the named ranges...but cannot find a way to access the Name Manager. The suggestion I find on the web to push command +fn + F3 does not work.

Please add the option of sorting dates "After or Equal to" and "Before or Equal to" a specific date range back into the Mac version of Excel. It still works that way on the Windows version, but disappeared with Version 16. This is a very commonly used filter with our entire team.

As title

On iPad in excel when I copy cells ( some with data, some without ) form one spreadsheet and pasting to another spreadsheet the cells with data are compressed together, without regard to blank cells

Previous editions of Excel had clickable icons for formula operators, very handy for inputting formulas using a mouse.

PLEASE give them back