FILTERS
 

HOW DO I GO ABOUT INSERTING A FILTER FOR EACH ROW THAT I HAVE DATA ON EXCEL

FILTERS
 

Filters only work on columns.

You cannot filter across a single row.

Please re-think your question and post back with what you actually need.


Gord Dibben MS Excel MVP

On Thu, 13 May 2010 07:01:01 -0700, EXCEL ROW FILTERS <EXCEL ROW
wrote:

HOW DO I GO ABOUT INSERTING A FILTER FOR EACH ROW THAT I HAVE DATA ON EXCEL

FILTERS
 

EXCEL 2007

Click in the top row of your data / Data / Sort & Filter group / Filter

If my comments have helped please hit Yes.

Thanks.



"EXCEL ROW FILTERS" wrote:

HOW DO I GO ABOUT INSERTING A FILTER FOR EACH ROW THAT I HAVE DATA ON EXCEL