Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .