A Secret Weapon For auto filter
Whenever you implement a filter to the column, the only filters accessible for other columns are definitely the values obvious within the at the moment filtered vary.We are able to use the excel shortcut keys Ctrl + Shift + L to apply filters into the column headers. You can click any header to use it all over the desk or on distinct headers to app