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.

When selecting multiple cells in rows or columns that are wider than the current screen view, I can usually only select the cells that are currently visible. This is a real problem when for example, I want to select data that might fill be hundreds of rows and/or hundreds of columns or even larger (I am currently working with a dataset that is more than 54,000 rows x 52 columns). The only way I can select multiple cells is to reduce the magnification on the screen so that the desired cells are all visible. Please fix this.

deduplicate one column vs. another, not just one column

OK. I discovered that I need an additional column or row. It used to be so simple: an insert menu. Now I can't find any way to do this, it certainly isn't simple anymore.

It seems that currently the maps feature can only be used on a state level for Australia. Would it be possible to have additional towns added so it could be a more useful tool please?

When copying cells with values to a different excel file, paste values does not work. Ctrl--cmd--v. Rather it does the annoying paste special

Paste values works within the same excel file, but not to a different.

Please fix

Entry in a password field of a UserForm should be masked in Excel 2016 Mac (as it was in Excel 2011 and in every Excel version on Windows)

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.

I need to import a structured xml file into excel. The xml file contains elements which contain other elements. I'd be happy to define a mapping which would excel allow to know, which elements/attributes to put into which column. The File I'd like to import is attached. However, this is jus one example.

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.