Forum Discussion
Hide Formulated Rows
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
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 again. I’ll give this a go. Think I might’ve been trying to overcomplicate it! Appreciate your time.
