Can I filter multiple column headers to display subheadings of each in Excel?
- by Gigi
I can't seem to find this anywhere... it may not even be possible without coding?
I have a spreadsheet containing more than one heading in a single column. These headings are identified with blue background and white font. Each of these headings have items listed below them. These "subheadings" are smaller, auto-black font and no fill background.
Currently I have to scroll down the spreadsheet to view all headers and their contents. How do I create a filter that would allow me to sort on whichever header I want, so that (only) the contents of that particular header are displayed?