Not a new idea, just return the Data Entry Form. I feel Excel has put itself back in the prehistoric era, maybe just a few seconds after the Big Bang, by removing the Data Entry Form capability. Why did MS remove it? It was around for decades, great feature.

remove duplicates by filtering

It would be really useful to be able to check/uncheck checkboxes in pivot tables without having to rely on the mouse i.e. using the spacebar

An empty column during SORT just ruined my entire dataset!!! It sorted the data only to the left of the empty column! Fix this please! Who would want to sort only part of their dataset if they had pressed SORT without selecting a subset of columns!!!??? Illogical functionality is DANGEROUS!

Today in the Mac version (16.44) the filtering funktion only reads the first 10 000 rows and there is nothing that give you a hint that this is the fact. (Sort funktion seems to work for at least 70K+ though). Please make this work or att least make the system tell you that the answer is wrong otherwise this can create gigantic problems......

HELP

So I just upgraded from an older version of office that I was very familiar with.

Now every time I try command + F, I have re-type what I was searching for.

Is it possible for the last search item to show up in the find bar? Would be great if it's already highlighted, in-case need to search for new item then can type straight away and no need to hit delete.

Thank you

Any table in Excel can be used as a database to select, extract and copy data to another location, for further use. Unfortunately the basics of it are not clear in Excel help, where discussions on PivotTables blurr everything.

First, define an Input Table containing all data, with column labels in top row.
Second, use Advanced Filter to define Criteria and Output range.
Criteria range must have two lines : one for column labels, one for sort values.
Ouput range needs one line only, with all chosen column labels in it. Selected data will display below it.

Enjoy !

none, other than GTH

I used to use this feature a lot on windows, now I have a MacBook I can no longer use it.

Data is great - now to set up a budget for 2021 and then have actual to budget by category.

In reviewing expenses: have customers date range and YTD -- also, on the snapshot, have the option look at more items.

For example, a single excel for all teachers in a school could include sheets with schedules for each day of the week, responsibilities/guidelines/priorities, student directories by grade, etc. If I could group the sheets for schedules together, or student directories of all grades, that would help organize the space.

For example, a single excel for all teachers in a school could include sheets with schedules for each day of the week, responsibilities/guidelines/priorities, student directories by grade, etc. If I could group the sheets for schedules together, or student directories of all grades, that would help organize the space.

An underlay behind the fliter menu to show the count of each value in the filter menu for that column.
This will give users a good indication of the impact of that value. In a second phase, hovering over the value could give a tool tip with the count or make the count show up on the right hand side of the filter menu.

Create step by step user tutorial for pivot tables.

Please provide the Find all button on the Mac version

The Autofilter shortcut is an available button in the Windows version that you can bring into the Quick Access Toolbar or ribbon. Select a cell and click the Autofilter button -> the selection is then automatically filtered by the selected cell. Currently, we have to navigate a long-winded context menu path. This would be a real time saver for all those working with reams of data in tables.

Wfhen applying a filter, it is currently not possible to copy and paste information without getting an error message