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.

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

I would like the ability to drag-and-drop rows and columns to re-order them. Google Sheets has this ability and I use it all the time. In excel if I want to move a row or column to re-order it, I need to use copy/paste and insert. It's a pain. If I'm viewing a list of items which I want to put into priority order, it is very difficult to do this in Excel. Whereas in Google Sheets, I can just drag and drop the rows to re-order them very easily.

When setting a table The “Forms” option is no longer available. Strangely enough that was one of the reasons I purchased 360.

It is annoying to have to unprotect a worksheet each time you need to open or close a group.

When protecting a worksheet, have a tick option to permit this or not.

Allow Mac users to create tables, graphs, and charts as easy as on Windows.