The size of the file and number of columns has NOTHING to do with my solution, or its robustness ... it does exactly what you want, using native filtering, preserving the Undo stack. You moan like someone who really doesn't know Excel, but would like it do some things precisely as you imagine, then complain when Excel does it a different, but valid, way. You also judge that Excel should never have made it into the big leagues ... how do you think that happened ... do you think that someone just decided: "oh, we'll have Excel in the big leagues" ... no, it happened only because so many people could see the advantages of using something so flexible, and powerful. Yes, I said "powerful" ... do you think that people like myself or Fluff haven't used enormous files in our careers? The last really big thing I did was achieved in Excel using PowerPivot ... a truly staggering step forward, if you are willing to explore it.