Excel 365 - hiding rows

%3CLINGO-SUB%20id%3D%22lingo-sub-2213017%22%20slang%3D%22en-US%22%3EExcel%20365%20-%20hiding%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2213017%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%20I%20have%20a%20large%20spreadsheet%20for%20TV%20Production%20budgeting.%20There%20are%20over%20100%20rows%20separated%20into%20sections.%20I%20am%20trying%20to%20find%20a%20way%20where%2C%20once%20the%20budget%20is%20completed%2C%20I%20press%20one%20button%20and%20the%20sheet%20hides%20(not%20deletes)%20all%20lines%20with%20a%20zero%20value.%20Anyone%20able%20to%20assist%3F%20Thank%20you%2C%20Bronwyn%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2213017%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2213210%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20365%20-%20hiding%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2213210%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F998585%22%20target%3D%22_blank%22%3E%40Bronwyn__Beez%3C%2FA%3E%26nbsp%3BI%20believe%20you'll%20find%20your%20answer%20in%20the%20attached%20link.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ffilter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c37dcc180e%23ID0EAACAAA%3DWindows%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ffilter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c37dcc180e%23ID0EAACAAA%3DWindows%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2233927%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20365%20-%20hiding%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2233927%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%20this%20worked%20perfectly.%20Cheers%2C%20Bronwyn%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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