Supress rows

  • Thread starter Thread starter AmyLRuck
  • Start date Start date
A

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.
 
Will Data->Auto Filter solve your problem? You can filter on Non Blanks for
the Col you want...
 
I could not get this to work for my data set.

Sheeloo said:
Will Data->Auto Filter solve your problem? You can filter on Non Blanks for
the Col you want...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Supress Rows Before Printing - Toolbar Icons become disable 2
Supressing a #VALUE! error returned? 3
Need the grand total pivot table filtered worksheet? 1
Calculated Item causes undue repitition in pivot table 2
supress leading zero 1
Hiding the 'printing' dialog box 3
Excel 2002 - Supress digits in a cell linked to a different workbo 2
Vlookup 1

Back
Top