If your data is formatted as an Excel table, then you can quickly sort and filter it with the filter buttons in the header row. Whenever you copy a static image of a visible, you can get a copy of the visual, such as filters placed on it, together with https://www.customguide.com/excel/excel-subtotal