Utilizo una planilla en la cual voy filtrando por distintos criterios y analizando la información. Resulta muy poco práctico cuando uno quiere cambiar el filtro,ir tildando y destildando el criterio.Y no existe una manera sensilla de ir eligiendo los valores del filtro. Se debería agregar una opcion de "filtro simplificado", de forma tal que uno al desplegar la lista pueda elegir con el mousse o deslizar con la flecha el próximo valor, tal como se hacía por ejemplo en la version del excel 2003. (lo más parecido que encontré es la opción que aparece en filtros avanzados)

The fields on the transactions tab allow filtering but not SORTING of transactions. Allowing them to be sorted by any of the various fields (amount, account, institution, etc.) would be very helpful.

How about a simple time sheet facility template for logging time to tasks and totalling each and reporting on them daily, weekly, monthly etc.

Data Sort does sorting differently in 2 similar scenarios

1. Ctrl A -> Sort
   Headers are respected and won't be sorted




2. Select All Arrow at the Top Left -> Sort
   Sorts by Column with no respect for Headers.

Just to let Microsoft know about it.

Is there a way to have the program compare free hand data in a cell to entries on a drop down list so that if you want to convert a freehand column of data to one that respects a list, you do not have to do them one at a time to do so? It is quite tedious to have to redo all of these entries one by one.

Stop fixing what isn't broken. "The split cell command is command is only available in Word 2016 instead of Excel 2016."

Have a table that is updated daily. First column is the date. Most recent (numerical) data is entered into the table on a row associated with that date from left to right. Each day will have a different number of entries. I would like to be able to pick up the most recent data entry on the row for that day and paste it into a different cell on the same row to the right - always the same column. Can't find that this option is currently available.

In the new money in excel please allow the sorting feature to work in the net worth tab accounts table. I tried to sort by account category A-Z and it tells me it is locked.

you have 'format cells \ special \ social security number, why not also include serial number, basically text, but keeps the begging letters and zero's, without getting formatting errors for using " '00 " to keep you're zeros.

Please allow the ability to copy an embedded link from a Microsoft Excel Spreadsheet as it only allows you to copy the display text without the link.

When customizing Slicer colors, the Slicer Element list is not in the same order as the color preview image. It makes relating the option to the preview confusing.

there is no way to find a keyword in the data I have and it is imperative that I use the find all button. I have to sift thru 30,000 to 50,000 rows when I import my spread sheets so it gets to be time consuming when I need to consolidate my information.

Searching numbers in Autofilter should be easy. Especially when numbers are already formatted as numbers, you shouldn't have to type separators (like","). In the latest version of Excel, you can't search for one-million unless you type "1,000,000". You should be able to type "1000000".

Not much of an idea but more of a feedback. The sorting rules are being deleted after data is deleted is not an improvement. I would prefer being able to manipulate my data without the worry of my rules being affected. Especially upon removal of all data to input a new set.

Normally, the Filter function in Excel can help us to filter any data as we need. But, sometimes, we would like to auto filter cells based on a criteria in a cell. The data will be filtered automatically at once. If we get this option that would be regretful.

It is hard to find quickly which columns have a filter on them. For that purpose, I would put those columns in light pink. It can be useful in case we don't want to erase all filters and just remove some of them.