In the Office Version "16.20 (181208)" for Mac, a "Change Theme" Drop Down Menu is missing. Me and Microsoft Support didn`t find any Menu.

Mojave10.14.2 + Excel fo Mac バージョン16.20（181208）+ 標準の「日本語入力」を使用。

入力規則で、日本語をオフ（英語モード）にしてあるセルを選んでも、オフにならない。

関数の引数に名前付き範囲を指定しようとした時、関数によっては関数ヒントで名前付き範囲が隠れてしまって見られなくなってしまう。
添付ファイルでは、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

On long spreadsheets, offer a popup that will automatically freeze the first column or row of data for easier reader use. I'm a teacher and I use excel for everything and this option is not always available on shared files.

When I click into a PivotTable from out of it (just from out of it) or when I move the selected cell over a PivotTable and stop there in the moment the PivotTable Analyze and Design menus appear the keyboard arrows don't move anymore.

If I click again over any cell of the PivotTable (i.e., when the menus are already loaded) I can use the arrow keys - what I think should be done automatically.

Fatturazione elettronica. Il foglio di calcolo più recente di Excel di Office 365 è 2004?

Create a pivot table from multiple tables (feature appears to be missing from Excel for Mac!)

The formatting for slicers won't work. When you click to modify a slicer style, all the options are table elements instead, not slicer elements.

so try this out. in one cell do 13/6 in another do 7/6. you'll get 2.166666667 and 1.166666667. Subtract 2 from the cell with 2.166666667 and 1 from the 1.166666667. You now have 2 cells with .166666667. Do an if statement on them to ensure they're the same. now take both cells and multiply them by 6. Both cells should contain 1. Do another If statement......They're different now right? Blow out the decimal places so it goes about 10 decimals deep and one changes to .9999999999990 while the other remains 1.....weird right?

don't delete the list of recent files when updating

don't delete the list of recent files when updating

Please allow users to disable horizontal scrolling (when trying to scroll vertically). When using two-finger scroll on a trackpad (like on a MacBook) it's impossible to pull straight down. There used to be a feature to disable this in Excel for Mac, but it has gone away.

The reason for this is that normally we only need to scroll vertically and am finding the when I use the trackpad I often scroll horizontally as well without intending to.

Just received updated Excel when opening Excel either from scratch or a document, an alert appears about ATP.xll File. Mac considers it a possible malware. Please remove.

I'm told by your support staff that one cannot resize a chart that is itself a sheet, ie not an object in a sheet. So to resize a chart I have to copy/move it to be an object in another sheet. Big pain.