when clicking the filter in a column, curser should be active in the data field. in this way the text can be typed in immediately

I would like you to implement the creation of spreadsheet tabs, within a tab of a spreadsheet.

I would like to use a multi/selection dropdown list to include several parameters to a field. Then I want to use the same multi/selection dropdown list in the autofilter function for selection of the filter parameters. The items for filtering are with OR. I don't want to see the different combinations of the items in the filtering selection list. The table shall show all lines which include the items of the filtering list.

Add the possibility to sort by date modified (oldest to newest and vice-versa) even when the cell contents are not a date.

Alternately, add a =DateModified() function so that the dates can be automatically pulled rather than manually input.

Since table can expand itself based on the number of rows, an SQL query like feature to fetch all the matching records from other Excel table can be brought in. Like SQL, all the other column values can be replicated to the matching records as required.

Month to month calendar to record daily activities eg. payroll on daily basis in excel eg names and days worked at pay scale. To be able to insert a calendar into a spreedsheet

Row to column not copy to another sheet to data copy

Hello! As of today (28-sep-2020) me and my coworkers have found that whenever we delete the filters in a table, the selection of cells and some other functions stop working as they should and we need to close EVERY Excel file we have open. This happens only when we use the filter in the Ribbon, because most of us have it customized. Hope you can solve this soon!

When you filter information to make it easier to review as the information on the table is a lot, therefore you need to move onto the next part, but currently you have to go onto the icon select the next piece of data and deselect the current piece of data to review next part of info, my Suggestion is to have small arrow next to the filter icon on the table to allow you to move up or down on the next part of the data without selecting and deselecting.

Remove duplicate column option. Within Excel we already have the ability to remove duplicate rows (within one ore more columns … though we do not have the ability to remove duplicate columns (within one or ore rows).

We also have the ability to transpose data, though would rather not have to 1st transpose data in order to then remove duplicates.

How do I create a macro that looks for a string in combo box columns data and show only matching results in excel.

The arrows used for filtering take up too much space.

I end up having to make columns wider than they need to be, just so I can see the title text in the heading cell.

Can you make the arrows much smaller, or place them in the header,
alongside the letters?

1. Allow a table column to be used as the Input Range in a Combo Box form control. Example "Customer[Name]". See attachment.




2. With a multi-step process, I am able to define a name for the column and use it. Example "CustomerName=Customer[Name]". However, (BUG) if I edit the Cell link, Excel erases the Input Range.

A column of full names (ie first and last) could be sorted by surname

Freeze Top Row, when combined with filters often leads to unexpected behavior. Today, the first row is not freezing on my sheet when I have filters enabled. There are also issues with cells not accepting focus (or at least displaying that focus has been accepted).

Allow to inverse filter selection with one click.

While analyzing data, I have have to change the filter to the opposite, to crosscheck. Depending on the formats and data quantity it can be time consuming

These days most worksheets have a lot of columns and are used collaboratively. As a result various users can put filters on columns of their choice, and when I see the worksheet I need to go clear all the filters to be able to see the full data. Instead of having to go to each column to clear its filter, I would rather have a single button or context/menu option to clear all filters.

I know how to create collapsible rows in excel by using the group data tool, but I don't like how it places the (+) and (-) down a row and all the way to the left. would love to locate these toggles in the same cell as the header of the data you are collapsing.

Table from image - which is available on phones should also be made available for desktop app.