Supress rows

[AmyLRuck]

How do I supress rows that do not have any calculated values in them? Ie - a
purchase order where there are orders for two items, and I want to hide the
rows without order information.

 

[Sheeloo]

Will Data->Auto Filter solve your problem? You can filter on Non Blanks for
the Col you want...

 

[AmyLRuck]

I could not get this to work for my data set.

Will Data->Auto Filter solve your problem? You can filter on Non Blanks for
the Col you want...

 

[Sheeloo]

Can you send the file to me?

I could not get this to work for my data set.

 

[AmyLRuck]

I would rather not. Where is the 'auto filter' capability on 2007?

 

[Sheeloo]

Ok.

It is under Data Ribbon in 'Sort & Filter' group