Excel for Windows (Desktop Application)
Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.
To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.
-
DE-DE: Fehler im Autofilter / Bug beim Rücksetzen aller Filter
Bereits seit Jahren hat Excel einen Fehler in den Autofiltern. Wenn man mehrere Filter in verschiedenen Spalten gesetzt hat, kann es sein (wenn bspw. die Reihenfolge rückwärts nicht eingehalten wird), dass auch nach der Option "Alle Filter löschen" trotzdem nicht mehr alle Zeilen angezeigt werden. Dann hilft nur noch das Markieren aller Zeilen und der Rechtsklick auf "Einblenden". Bei gesetztem Blattschutz allerdings sehr ungünstig.
Erstmals fiel mir der Fehler in Office 2003 auf, wurde seitdem nicht behoben. Auch in der aktuellen 365er Version ist das gleiche Spiel.
IDEE: Fehlermeldungen aus Excel heraus direkt an MS ermöglichen - ohne Umweg über…1 vote -
Add Sort Option to sort 'blank/no value' cells first or last
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.
1 vote -
Trailing Date Filters
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.
1 vote -
Multiple values in one cell
Provide way to enter multiple values into a single cell AND then view these as separate rows (e.g., in Pivot table or via formatted Table).
E.g., A1 = "Banana", B1 = "Fruit, Yellow"
Then provide way to view table that shows "Banana" TWICE (as two rows: under "Fruit" and "Yellow").1 vote -
Making a directory in Word importing information from Excel.
How can I make a directory using text information from Excel and photos? I'd like to put them in a Word Table. This needs to be updated several times a year, so would like to be able to insert information as it changes.
1 vote -
1 vote
-
Need to Merge Two Cells
Need to merge 2 Cells
2 votes -
Create a "Table" sheet type
Can we have a "Table" sheet type, similar to a chart sheet? It can only contain a single table with no cells outside the table, but could grow/shrink as required, and should have improved navigation / deletion / insertion capabilities
2 votes -
Allow insert copied cells for whole rows in tables
Allow user to use the "Insert copied cells" in a table when they have selected an entire row. This is needed to quickly replicate rows in a table. The limitation seems inconsistent with the following:
* Users can already "Insert cut cells", just not copied cells.
* Users can insert a blank row, then copy another row over the blank row, which is functionally equivalent but two steps.2 votes -
Horizontal filtering
ONE VERY USEFUL feature is still lacking: "HORIZONTAL FILTERING" - i.e. ability to filter, hide, sort, ONLY COLUMS which fulfil certain criteria.
Grouping works both for columns and rows...
Hiding works both for columns and rows...
Filtering works only for columns - maybe it is time to go from 1D to 2D?1 vote -
In Excel filtered column drop down scroll (Select All) menu should be fixed instead of scroll hide after list go scroll down
In Excel filtered column, when i am going to select drop down and scroll the list that time (Select All) menu going scroll accordingly. If fridge or fixed the (Select All) menu list, it will more help when I go down more and more and need to check out all then have to go back again first, So it should be fixed the (Select All) menu list that will really helpful to user. Screen captured for better understanding the issue.
Thanks1 vote -
In Excel filtered column drop down scroll (Select All) menu should be fixed instead of scroll hide after list go scroll down
In Excel filtered column, when i am going to select drop down and scroll the list that time (Select All) menu going scroll accordingly. If fridge or fixed the (Select All) menu list, it will more help when I go down more and more and need to check out all then have to go back again first, So it should be fixed the (Select All) menu list that will really helpful to user. Screen captured for better understanding the issue.
Thanks1 vote -
Filter doesn't show Oct, and Nov Month in large dataset
I applied a filter on a large dataset which consists 30k row its shows the months till Sep but not Oct and November
1 vote -
Improve the functionality of data tables:
Improve the functionality of data tables:
- so you can control which data tables need updating and others that don't need updating everytime you do a calculation. This would improve the performance of updating calculations where only certain aspects of the model have changed.
- make it easier to run nested data tables1 vote -
해 찾기 추가 기능 - 종속변수 활성화 체크박스 추가
해 찾기 추가 기능에서 종속 조건 변수에서 체크 박스를 추가하여 활성화 및 비활성화 기능을 사용 할 수 있게 만들어서 활성화 시켰을 때 결과 값과 비활성화 시켰을 때 결과 값을 비교 할 수 있었으면 좋겠습니다
1 vote -
[Accessibility] Keyboard shortcut to move rows and columns
ALT+SHIFT+ARROW_KEY, similarly to tables in word and OneNote
1 vote -
Return refresh auto filter old style
Please return to old-style refresh autofilter method.
On 2016 version, it is necessary to re-aply filter to refresh the results.
In older version, after select an item in a column, others colums was already filtered.1 vote -
Excel AutoFilter
Summa securos acie apparere dum scrolling adde transitum. Commode enim magnum lists
1 vote -
Dependent Drop Down Lists Using a Master Table of All Possible Combinations as a Data Source
Referencing the attached table, the idea is to have the first drop down list show "Distinct" items of the [Family] column, the second drop down list shows the corresponding items from [Product] column. this opens a wide door for utilizing Excel as an data entry system for customized solution specially for small businesses. Thank You!
2 votes -
Add F4 toggle to "lock" structured refrences
Structured references are awesome. But making them relative/absolute is not! Let us use the F4 shortcut on structured references too.
3 votes
- Don't see your idea?