Related:
- Conditional formatting hide rows
- Excel clear formatting - Guide
- Conditional formatting if cell contains text - Excel Forum
- Steam hide comments - Guide
- Excel conditional formatting based on date - Guide
- How to use conditional format based on text? ✓ - Excel Forum
2 responses
I had this same question, and after not finding an answer I thought I'd figure it out.
Here's what I did
- Created a new column that gave me a value I could filter on
- Used filter feature to include/exclude the values.
For example, I wanted to "hide" the rows where the sum of columns C, J and K were zero. So I created a new column "L" with a formula of "=SUM(C2,J2,K2)". Then I clicked on the L1 title cell, then went to Home ribbon tab and clicked Sort & Filter --> Filter. This allowed me to drop down that L1 title cell and remove the "0" from the list of allowed values.
Hope this helps!
Here's what I did
- Created a new column that gave me a value I could filter on
- Used filter feature to include/exclude the values.
For example, I wanted to "hide" the rows where the sum of columns C, J and K were zero. So I created a new column "L" with a formula of "=SUM(C2,J2,K2)". Then I clicked on the L1 title cell, then went to Home ribbon tab and clicked Sort & Filter --> Filter. This allowed me to drop down that L1 title cell and remove the "0" from the list of allowed values.
Hope this helps!
15 Feb 2012 à 01:12