Use the Filter Buttons I've already mentioned the filter buttons in Excel tables several times in this guide, and that's because they're a real time-saver.

How to create an Excel table 1. First, enter the field names in the columns across the top, and then enter some records/data in the rows under each column.

The slicer buttons don’t automatically update. How to update the button sort order in Excel Microsoft Excel won’t sort the buttons automatically — it isn’t a dynamic feature.