Excel Help
My feedback

1,426 votes216 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!
Thanks
Ashvini Sharma
Lead Program Manager
ExcelExcel Help supported this idea · 
3 votes5 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Excel Help shared this idea · 
4 votes4 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Excel Help commentedKenneth I bring it up because this, like so many other intuitive and timesaving features, is a native feature in Google sheets. I'm sure you've either seen in these forums or experienced yourself that Google is much more attentive to user input and more aware of how we use their products than MS is, and the fact that this autocomplete already existed there before I even knew I needed it is a testament to how many people would use it in Excel.
Excel Help shared this idea · 
26 votes8 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Excel Help commentedI'd love to use addins to solve numerous Excel shortcomings, Gareth, but our organization requires we use MS products outofthebox.
Excel Help shared this idea · 
9 votes4 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Excel Help supported this idea ·

64 votes13 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Excel Help supported this idea ·

5 votes2 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Excel Help commentedLove this suggestion. It's the reason I sometimes avoid IFERROR and construct my own error checking.
Excel Help supported this idea · 
2 votes0 comments · Excel for Windows (Desktop Application) » Opening and Saving Files · Flag idea as inappropriate… · Admin →Excel Help supported this idea ·

2 votes0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Excel Help supported this idea ·

6 votes1 comment · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →Excel Help supported this idea ·

3 votes0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Excel Help supported this idea ·

3 votes0 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →Excel Help supported this idea ·

11 votes2 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →Excel Help supported this idea ·

7 votes2 comments · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →Excel Help supported this idea ·

48 votes10 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Excel Help supported this idea ·

51 votes6 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
Thanks for all of the suggestions related to filtering. Unfortunately, we will not be able to address this in the near future. We’ll continue to track the voting.
SharonAn error occurred while saving the comment Excel Help commented3. Add Shift+click functionality to the filter menu, for selecting large numbers of consecutive items, but still fewer than the total list.
Excel Help supported this idea · 
11 votes2 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →Excel Help supported this idea ·

12 votes2 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →Excel Help supported this idea ·

382 votes70 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
Thanks for the suggestion Levi! We’ll be taking a look at this along with some other asks around conditional formatting. It’s a big help to see the things with the most votes, particularly within areas like formatting. So please keep the votes coming for things you want us to do sooner!
Thanks,
John [MS XL]An error occurred while saving the comment Excel Help commentedAll of the above comments, I second. In addition, I've noticed a weird bug where the "Applies to" field turns blank for some rules as I'm scrolling through many rules. Change or delete a rule, and it comes back. But randomly that field is missing the cell references.
Btw MSFT, considering this "under review" for two years isn't very comforting. Can we get an update? Your power users are begging for long overdue changes to CF.
Excel Help supported this idea · 
237 votes24 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
Great suggestion, thanks David! And thanks to other people who took the time to clarify/comment on this one. There’s definitely room to tighten this experience up in a number of places. We’re getting a lot of traffic on the site, so please keep voting for the things you care about most to help us do a great job of prioritizing.
Best,
John [MS XL]Excel Help supported this idea ·
Kenneth, I understand the syntax perfectly. As I wrote in my description and showed in the screenshots, I did use @ in one of my trials and it made no difference (and you can try it yourself, too you know!) Regardless, a wholecolumn reference like Table[Column], when used in a 1:1 relationship between the tables and with formula autofill turned on, DOES WORK. However, it only works when the A1 notation is the exact same in both worksheets. My post is about this second caveat.
The fact that it works only when the tables are aligned in physical space is the issue. Tables are supposed to be independent of their A1 notation and that is the strength and purpose of structured references. It's the result of an oversight; a bug in the program.
User Voice is for feedback on the software, not for soliciting solutions. I didn't ask for a lengthy workaround via helper columns, I'm trying to make the issue visible to the Excel team with the help of the User Voice community.