Related:
- Excel conditionally hide rows without vba
- Excel conditional formatting hide row - Best answers
- Conditional hiding excel - Best answers
- Excel Conditional Formatting Rows to Columns ✓ - Forum - Excel
- Conditional hide rows in multiple sheets ✓ - Forum - Excel
- Excel conditional formatting row color ✓ - Forum - Excel
- Excel - Conditional formatting for an entire row - How-To - Excel
- Repeat rows in Excel: based on cell value, VBA - Guide
2 replies
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!
sarbel.vilo
Feb 26, 2009 at 03:15 AM
- Posts
- 233
- Registration date
- Tuesday November 18, 2008
- Status
- Member
- Last seen
- August 1, 2010
Feb 26, 2009 at 03:15 AM
In that case you should change the borders at the right top side of your screen. As far as I know.
Feb 15, 2012 at 01:12 AM