Forum Discussion
Solved
Hide Formulated Rows
I have a tab which is formulated to produce a short sentence from data input on previous tabs. If select Yes then sentence is formed on comments page & if left blank then formula for the sentence retu...
Sergei is correct. The easiest way to do this without VBA code is to apply a filter to the column.
1. Add a column header then select the column range and then click Data > Filter
2. Click the dropdown arrows and uncheck 'FALSE'
3. The rows with 'FALSE' will now be hidden
NOTE: The filtered rows will not automatically updated if values change. You will have to refilter it each time by unchecking and then rechecking 'FALSE' in the filter
Thanks very much for the response. I’m really hoping to hide the entire row if possible.
Can you send a screenshot example of the rows ?
- The “FALSE” rows are the ones I want to hide. They are formulated from prior tabs with IF formulas & if satisfied show a short sentence like the one in the attachment about rental income. If they remain false I’d love to hide them. Thanks again so much for your time & responses 🙂
Did you try to apply filter to column C (select it, Data->Filter) and uncheck FALSE in filter drop down?
