Excel 365 - hiding rows

Question

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

riny_van_eekelen · Answer

Bronwyn__Beez&nbsp;I believe you'll find your answer in the attached link.https://support.microsoft.com/en-us/office/filter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c37dcc180e#ID0EAACAAA=Windows&nbsp;

bronwyn__beez · Answer

Riny_van_Eekelen&nbsp;Thank you, this worked perfectly. Cheers, Bronwyn

Forum Discussion

Excel 365 - hiding rows

2 Replies

Resources