| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Suppress a row
Can you suppress a row of data when a cell in that row is zero?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Suppress a row
When you say suppress the row, do you mean hide it?
You can do that via the filter tool--Data--Autofilter. In the column for which you want to test for 0 values, just apply the filter 0. Dave -- Brevity is the soul of wit. "DCN" wrote: Can you suppress a row of data when a cell in that row is zero? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Suppress a row
You can set the Conditional Formatting of the row to change the font color to
the same color as the backbround if the target cell is zero. The row or data will still be there, it will just appear to be empty. Vaya con Dios, Chuck, CABGx3 "DCN" wrote: Can you suppress a row of data when a cell in that row is zero? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I suppress values from appearing in a graph? | Excel Discussion (Misc queries) | |||
| how do I suppress printing blank lines in a worksheet? | Excel Discussion (Misc queries) | |||
| Suppress Update Links Message | Excel Discussion (Misc queries) | |||
| how to suppress office assistance dialog | Excel Discussion (Misc queries) | |||
| How can I suppress a portion of a line graph? | Charts and Charting in Excel | |||
Linear Mode
