ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to hide rows having a specific value in cell of column A ? (https://www.excelbanter.com/excel-discussion-misc-queries/446928-how-hide-rows-having-specific-value-cell-column.html)

François Delepine

How to hide rows having a specific value in cell of column A ?
 
I have a big worksheet containing historical cash flow movements. I need to automatically hide the rows where the first cell (column A) of the row is containing a specific value (999).
Is there a way to achieve this without a macro? If not what would be the code to insert?

Spencer101

Quote:

Originally Posted by François Delepine (Post 1604888)
I have a big worksheet containing historical cash flow movements. I need to automatically hide the rows where the first cell (column A) of the row is containing a specific value (999).
Is there a way to achieve this without a macro? If not what would be the code to insert?

You could use a filter set to column A does not equal 999.

That would hide all of those rows.

Is that what you mean?


All times are GMT +1. The time now is 01:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com