Slicers are great for discrete data such as sales regions, but don't support continuous data such as a range of sales dollar amounts. Timelines support continuous data, but only dates. It would be very useful to have a feature that combines these, working similarly to a Timeline but allowing numbers, dollar amounts, etc. The workaround I've seen is bucketing the data (sales of $100-$500, $500-$1,000, etc.) but that limits user flexibility.

This ties in with recommendations of others where they recommend changing the color of the filter button to easily identify filtered columns. Also consider providing drop down option or pop up option to list column names (with alphabetical label of column, such as (A), (B), etc). This will help to easily identify columns where filters are applied. You don't necessarily want to go to each column, but rather want to catch up with the logic / thought process you were busy with. Maybe some short abbreviated info about the values filtered as well.

WHEN YOU USE FILTER THE CURRENT FILTER TOOLS IS LESS THAN,GREATER THAN AND BETWEEN THERE SHOULD BE MAX AND MIN TO FILTER THE ABSOLUTE MAX DATA REFERENCE TO UNIQUE NAMES FOR EXAMPLE

Advanced Filter Option to Exclude a list of items
You have a list of 10,000 members. You want to filter the list so that if any of the 900 in this criteria list are present, it will EXCLUDE them from the filtered list.
Comes up all the time, we handle it with conditional formatting and color sort or with VLOOKUPs and subsequent sort.
Seems like it should just be there when you go to filter.

Insert traffic light colour function as an "IF" scenario in the table section. so for example if a number drops below certain precentage its red category, another precentage its amber, then green.

When the Sort ....(choicest) selected "Sort Warning" box pop-up with a preselected choice. Remove that "preselected" default setting and enable it to remember users choice when Excel is open and used next time.

I noticed today that the behavior of the autofilter has changed and I can no longer define the range relevant to the filter - actually I can but then Excel decides to change it adding lines I have below the table in the filter range. This makes the filters behavior much harder to control.

Currently when there's only one row left in an Excel Table (ListObject) and you delete the whole row, the Worksheet_Change event is not fired.

Request: Please make it raise the event.

I often use different colours in my spreadsheets. However it is a pain that you can only filter by one colour at a time ...can there be a check box by the colours when filtering by colour ...so you can select specific one or more colours, or multiple colours at the same time ...this would be awesome and a massive improvement to Filtering …..can this be so difficult for the Microsoft excel team to implement ? must be an easy fix going forward …...please vote for this if this will help you out !!

Allow table names to be scoped to the worksheet rather than have them scoped to the Workbook.

Your current 'workbook' scope implementation means that for similar worksheets I have to come up different table names to prevent them from clashing

Add ability to sort by other than the first charcters in a cell.

For example, a list of first and last names could be sorted by last name by sorting on the second word.

Microsoft Excel my goal is to make the whole sheet uneditable and editable both at the same time.

For instance, I'm using Table1 and with every new entry, one row adds up in the table, but the whole table is prone to risk of being mistakenly or deliberately removed/edited. I want to make a new entry (which will add a new row, aa usual) but the whole should remain protected/locked (unchangeable). Have i conveyed my point?

When spilling information from one sheet to another, the formats of the cells do not carry over.

I'm on a live updating spending tracker with stat spill tables that auto fill. I also have a huge Grand Totals sheet where I can over look all ov my months. When spilling the information from one sheet to another, only the values show on the second sheet. Meaning currency, percentage, etc.

While building tables or creating charts ; i always have to go Adobe Color to match colors in the charts to make them more appealing. An addon or right inside color picker if we were to have suggested color options ; it would help many to create more appealing stuff in excel.

Automatically adjust Sl.No when we add/modify/delete a row

Please add a sort option where the user can specify if they want blank cells sorted at the beginning or the end.

When sorting it doesn't matter if ascending or descending is selected, currently blank cells always sort at the bottom of the table. I'd like to see the ability for the user to select if they want blank cells in a table sorted at first. Attached is a perfect place to put it.

Add trailing ("Past") date filters. These are different from the "Last" filters.

On 6/15/2019, the "Last Year" is 1/1/2018 - 12/31/2018. The "Past Year" is 6/15/2018 - 6/15/2019. "Last Month" is 5/1/2019 - 5/31/2019. "Past Month" is 5/15/2019 - 6/15/2019.

This can apply all the common ranges: Past X days / weeks / months / years.