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 am working with an excel 2007 worksheet that has the "filter" applied so that each column heading has a pull-down menu for sorting. When I add new rows to the end of the table by cut-n-paste from the last row, these new rows are not included in the sorting. I can't seem to get the newly added rows to be included in the filter range. I tried un-selecting and re-selecting the "filter" button and also tried the "reapply" button. The "clear" button is always greyed out. I can't seem to find any relevant help for this online anywhere. Not sure if it matters, but the heading row and the first column are set to be "sticky" (they don't scroll with the rest of the table.)

share|improve this question

migrated from Oct 7 '12 at 8:30

This question came from our site for professional and enthusiast programmers.

I eventually just deleted the file and started over. Works fine now. Wish I knew what caused that problem... Thanks anyway. – user9645 Oct 26 '12 at 20:56
"sticky" is actually called frozen panes. FYI. – KronoS Jan 15 '13 at 16:29

You must log in to answer this question.

Browse other questions tagged .