Improve Table Design Tab Appearance and Functionality
There is No synchronization between the Filter command on the Table Design Tab and the similar command on the Data Tab. So if you apply a Filter from the Data Tab then clear it, the corresponding Filter command on the Table Design is inactive. On the Other hand, if you insert a Slicer from the Table Design Tab ► it inactivates the Filtering commands on the Data Tab. Filter on all tabs should synchronize together as well as with the Slicer.
Looking at the distribution of commands on the Table design Tab, I would prefer removing the Filter command from the Style options group (it has nothing to do with formatting) and rather group it with the Slicer button in the Tools group. to avoid any confusion I would also move the 6 options affecting the styles, to the right side of the Styles gallery. Look at the before and after design.
Nabil Mourad (MVP)
shared this idea
2 comments
-
Anonymous
commented
I agree with this suggestion to change in excel.
-
Nabil Mourad (MVP)
commented
Other issues with Tables that need to be fixed:
# The "Subtotal " Tool is inactive with tables but works with lists.
# Copying multiple Sheets having tables simultaneously gives an error
# We cannot convert a spilled array into a Table or use it in Power Query