ATTENTION: You are viewing a page formatted for mobile devices; to view the full web page, click HERE.

Main Area and Open Discussion > General Software Discussion

Excel 2007 question


To all,

I am looking for a way to have a text field in excel 2007 where I can type in a value and have excel filter out all rows that do not contain that text.

Does anyone know of a way to do this in excel 07?


ASAP Utilities is a fantastic, free Excel add-in that should allow you to do this, although I suspect you already have it installed and that I've misunderstood what you're after  :o

advanced filters are supposed to be able to do this, though having said that I've never been able to get it to work...

You could write an on change routine to amend the existing filter criteria though


[0] Message Index

Go to full version