| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Supress rows
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Supress rows
Will Data-Auto Filter solve your problem? You can filter on Non Blanks for
the Col you want... "AmyLRuck" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Supress rows
I could not get this to work for my data set.
"Sheeloo" wrote: Will Data-Auto Filter solve your problem? You can filter on Non Blanks for the Col you want... "AmyLRuck" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Supress rows
Can you send the file to me?
"AmyLRuck" wrote: I could not get this to work for my data set. "Sheeloo" wrote: Will Data-Auto Filter solve your problem? You can filter on Non Blanks for the Col you want... "AmyLRuck" wrote: 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Supress rows
I would rather not. Where is the 'auto filter' capability on 2007?
"Sheeloo" wrote: Can you send the file to me? "AmyLRuck" wrote: I could not get this to work for my data set. "Sheeloo" wrote: Will Data-Auto Filter solve your problem? You can filter on Non Blanks for the Col you want... "AmyLRuck" wrote: 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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Supress rows
Ok.
It is under Data Ribbon in 'Sort & Filter' group "AmyLRuck" wrote: I would rather not. Where is the 'auto filter' capability on 2007? "Sheeloo" wrote: Can you send the file to me? "AmyLRuck" wrote: I could not get this to work for my data set. "Sheeloo" wrote: Will Data-Auto Filter solve your problem? You can filter on Non Blanks for the Col you want... "AmyLRuck" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Supress rows | Excel Discussion (Misc queries) | |||
| Supress #Ref! error | Excel Worksheet Functions | |||
| how do I supress text in a column? | Setting up and Configuration of Excel | |||
| #div/0! how do i supress? | Excel Worksheet Functions | |||
| Supress error message | Excel Discussion (Misc queries) | |||
Linear Mode
