Excel 365 - hiding rows

Copper Contributor

Hi there, I have a large spreadsheet for TV Production budgeting. There are over 100 rows separated into sections. I am trying to find a way where, once the budget is completed, I press one button and the sheet hides (not deletes) all lines with a zero value. Anyone able to assist? Thank you, Bronwyn

2 Replies

@Riny_van_Eekelen 

Thank you, this worked perfectly. Cheers, Bronwyn