It would be great if Excel for Mac (Insiders) is able to have the new Stocks functionality currently used by Excel for PC (Insiders)

This functonality is described in https://support.office.com/en-us/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54

In respect of this particular capability, it would bring Excel for Mac more in line with Apple Numbers which currently offers something similar.

Thank you for considering this addition.

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.

deduplicate one column vs. another, not just one column

関数の引数に名前付き範囲を指定しようとした時、関数によっては関数ヒントで名前付き範囲が隠れてしまって見られなくなってしまう。
添付ファイルでは、3つある名前付き範囲が2つしか見えていない。一番最初（上）にある名前がヒントで隠れてしまっている。

LOOKUP関数の引数TRUEとFALSE、MATCH関数の照合の種類、SUBTOTAL関数の集計の種類などが表示されない。
Windows版のExcelだと、数式の入力の際にその箇所にカーソルが来ると、全てが表示される。

It used to be possible to enter a date or a time with these shortcuts I wrote in the headline, without selecting a specific cell.

Now it needs to do a double click in a cell, to enter the date or the time.

I know its not a big deal, but for me personally (hopefully for many others as well) is it better the way it used to be.

With the best wishes
Jan

It used to be possible to enter a date or a time with these shortcuts I wrote in the headline, without selecting a specific cell.

Now it needs to do a double click in a cell, to enter the date or the time.

I know its not a big deal, but for me personally (hopefully for many others as well) is it better the way it used to be.

With the best wishes
Jan

Excel 2011 had the possibility to sum individual cells by typing "=", and then just clicking on individual cells across the workbook that you want to sum, and "return" when done. This functionality is no longer available in Excel 2016 (you have to type "=sum(", then clicking on the individual cells while holding down the command key, "return". I would be happy if the old functionality is brought to Excel 2016.

Please make same function excel for mac and window users so that we could be easy to use and command or shortcut key also be same.

If you protect a sheet, Trace Precedents/Dependents no longer works, even if you can see the formulas. This can be annoying if someone wants to see the calculation flow, but the author doesn't want anything changed.

Either completely disable formula tracing only if the formulas are also set to hidden or add another option to the Protect Sheet dialog to toggle this on or off.

How about a function that returns the root of a cubic equation? That is, return the value of x for the equation ax^3+bx^2+cx+d=0 for given parameters a, b, c, d.

You can, of course, search, one by one, for all instances of a matching string in Excel using the 'Find' dialogue box. But why is it still not possible to return multiple instances with just one click and then select each one in turn to find it in the spreadsheet? You have been able to do this in Windows versions for years! Also, why is it necessary to dismiss the dialogue box before you can go to the found string? This is not the behaviour of Excel for Windows. Admittedly, it could be a limitation of the Mac OS.

I have created a UDF in VBA and it only shows up if I use the = sign. It does not show up in the insert function utility nor does it show any of helpful variables to show how to enter the data. Even Shift-Control-A does not work. It would be helpful to see what UDF formulas are available and how to enter the data for the UDF.

It would be great to have the ability to use a function that targets a cell and when the target cell receives a value gives a "static" Date and Time stamp. Also have a true/false option for updating timestamp when target cell value changes.

Currently the only options are VBA or circular reference. NOW just isn't any use for static timestamps?? Or have

My one suggestion as a finance professor: For PV, FV, & related functions, users should never need to add a minus before certain inputs. =PV(5%,9,100,) should give you $710.78, not ($710.78). Right now, we need to use =PV(5%,9,-100,) for a correct answer. Students get confused!

Would like to be able to use named ranges across multiple worksheets. I have pay and grade amounts that need to be used in several different worksheets that are date dependent. I would like to be able to use the names OR the lookup function that uses the named ranges across the worksheets. It is not feasible to have each of these worksheet as tabs in a master sheet. This is a weekly task related to tracking costs.

When using the YEARFRAC function for calendar year, e.g. 1/1/17 - 12/31/17 it gives correct calculation of 1. But when using it for academic year of 7/1/17 - 6/30/18 it gives calc of one day less = .9972
Can you please fix this?