Be able to filter information in the chart, similar to what exist on windows.
Example attached(image)

Please make the Data Validation List feature work with array constants.
Like to be able to define a named Array Constant and use that in a Validation List. After all they are both lists and the Data Validation list works with a classic Named Array.

Requirement scenario is to share a workbook across organisations and ensure consistent data entry or option selection without VBA, as VBA is often stripped/blocked at organisational boundaries. This would be a very simple and straightforward solution improving user experience and organisational efficiency.

Multi tested on various computers, a 5 Mo Excel file takes 2,5sec with Excel 2019 when it takes more tham 80sec with Excel 365. Great disconfort for users. Is it just the fact the Excel 365 is a cloud based design program because, even off-line, it is the same result. Thanks

The latest Excel for Mac (v 16.29 and later) can refresh from Text, CSV, XLSX, XML and JSON files, but not when those files are on SharePoint Online (or other cloud storage locations). Please add this functionality, as we are moving to SPO and away from file servers. I know I can refresh from a local copy (via OneDrive sync client), but each person's local file path may be different, so a shared Excel file won't update correctly for each person.

I would like to easily highlight a cell with the touchbar but the color i most frequently use or even the "last" color used is not an option. I suggest you include whatever color is in the highlight/fill button be included in the touch bar.

improve the filter function in excel for Mac - make it work the same as with excel for PC

You need to complete rewrite the code. Excel for Mac is the worst Microsoft product ever.

Conditional formatting which uses named ranges in the condition, can't be copied between two workbooks. It can be copied only within one workbook.
Identical conditional formatting that uses unnamed ranges can be copied between workbooks without a problem.
This bug is in versions 16.35 and 16.37.

PLEASE FIX!

When selecting a cell and changing the format to "Currency," the cell vanishes. The value is still there, however is does not display to screen. When re-formatting back to "Number" the cell re-appears.

Enable the creation of USERFORM in eXCEL 16
Please take this request into account and enable the functionality of creating userforms in EXCEL from VBA. It is a very important functionality.

I compared the "Manage Rules" feature on Windows and Mac, I found that the difference is Windows has the "Apply Rule To", however, Mac doesn't have it.

I want to see my previous data sometimes even if I delete it, so even after I save a document, I want to go back and view what I put originally so I don’t have to re-enter that idea if I want to go back.

Hi Team,

Since the upgrade of 2016 MS office in excel Autoformate feature is not available. Could you please tell me how to get it right.

It is On MAC OS

Hi Team,

Since the upgrade of 2016 MS office in excel Autoformate feature is not available. Could you please tell me how to get it right.

It is On MAC OS

配列数式を　組む際に、
　・セル間配列数式値の　受け渡し、
　・ネスト間配列数式値の　受け渡し、
此等において、

ご存じの通り、
阻害条項が　横たわっており、

連れて、
名前定義を　介したり、
INDEX構文を　持ちいたり、
等、

阻害への　特殊な、
対応が　求められます。

又、

OFFSET構文等の、
索引関数の　結果を、
上位ネスト関数に　引き渡す際にも、

かなり　以前から、
不具合が　見られるように、
なっていますし、

他にも　有る、
可能性も　横たわっています。

一方、

もし　此等を、
VBAで　なそうと、
する場合、

ループ等での　対応が、
一般的です。

ですが、

此では　オブジェクトタッチ数が、
飛躍的に　増え、

連れて、
必要処理時間が　飛躍的に、
増加するだけでなく、

プリセット機能である　シート関数の、
有用性を　殺し、

併せれば、
Excel　其の物の、
価値を、能力を、
毀損しています。

Excelの、

持てる　能力の、
全てを　毀損させず、
余す事なく　発揮させるためにも、

配列数式への　改善を、
図っては　如何でしょうか、

ご検討を　願います。