| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding Formulas when the value is "0"?
Does anyone know if Excel allows you to hide a formula when the result of the
formula equals "0"? I have a huge spreadsheet that makes it difficult to briefly scan the report and locate number values greater than "0" because there are so many formulas that equal "0". Existing View: 0 0 0 4 0 0 0 0 1 0 0 0 7 0 0 0 0 0 Preferred View: 4 1 7 I don't want to see the zeros as in the "Existing View" above and want the spreadsheet to appear like "Preferred View". I want to keep the formulas in the cells that equal "0", therefore I don't want to delete them to make the cells look blank. Any feedback is appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine logical formulas "if", "and", "or" | Excel Discussion (Misc queries) | |||
| Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
| How do display a "+" or "-" sign when hiding columns? | Setting up and Configuration of Excel | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Threaded Mode
