Hide rows that equal $0

[lmmay]

I have a spreadsheet cols a-ab, rows 7 to 2498. I need a macro to hide all rows when AB equals 0.

 

[Joe4]

Easiest way to do that is to simply apply a filter on your data, and filter out the rows where column AB is 0.

 

[lmmay]

Easiest way to do that is to simply apply a filter on your data, and filter out the rows where column AB is 0.

Thank you. Didn't want to re-sort my data however it was easy to do.

 

[Joe4]

Thank you. Didn't want to re-sort my data however it was easy to do.

You are welcome.

Note: Using the built-in Filter functionality will NOT re-sort your data. It will simply hide all the rows where that column is 0.
If you had to re-sort, you are not using it correctly.
See here: Filter data in a range or table - Microsoft Support