Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
    
Welcome to Super User. If Peter’s answer (or any other that has appeared by the time you see this comment) is what you want, that’s wonderful. But if not, it’s because your question is unclear. Please edit your question to try to explain your problem more clearly. If you can, post your Excel file (i.e., a minimized copy of it) and/or a screen snapshot of it somewhere on the web, and post the URL here. Failing that, try representing it as a code (preformatted) block. –  Scott Feb 22 '13 at 21:44

1 Answer 1

Since you are using Excel 2010, you can use the "Filter by Color" function of the Autofilter:

enter image description here

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.