Home

HELP EXCEL FILTER ROWS

%3CLINGO-SUB%20id%3D%22lingo-sub-911331%22%20slang%3D%22en-US%22%3EHELP%20EXCEL%20FILTER%20ROWS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-911331%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIm%20trying%20to%20build%20an%20excel%20a%20sheet%20that%20auto%20hides%20rows%20based%20on%20a%20drop%20down%20selection%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehow%20do%20I%20hide%20rows%20automatically%20based%20on%20the%20drop%20down%20menu%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20instance%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHires%3C%2FP%3E%3CP%3ERow%201-10%20viewable%20and%20it%20hides%2011-20%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETerminations%3C%2FP%3E%3CP%3ERow%2011-20%20viewable%20and%20hides%20row%201-10%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-911331%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-918777%22%20slang%3D%22en-US%22%3ERe%3A%20HELP%20EXCEL%20FILTER%20ROWS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-918777%22%20slang%3D%22en-US%22%3EThe%20new%20FILTER%20function%20is%20your%20solution.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fclient%2Fresults%3FHelpID%3Dxlmain11.chm60662%26amp%3Blcid%3D1033%26amp%3Bsyslcid%3D1033%26amp%3Builcid%3D1033%26amp%3BShowNav%3Dtrue%26amp%3BVERSION%3D90%26amp%3BNS%3DEXCEL%26amp%3Bapp%3Dwebview%26amp%3Bcontext%3D%257BAppVersionMajor%253A16%252CAppVersionMinor%253A0%252CAppVersionBuild%253A11929%252CAppVersionUpdate%253A20002%257D%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fclient%2Fresults%3FHelpID%3Dxlmain11.chm60662%26amp%3Blcid%3D1033%26amp%3Bsyslcid%3D1033%26amp%3Builcid%3D1033%26amp%3BShowNav%3Dtrue%26amp%3BVERSION%3D90%26amp%3BNS%3DEXCEL%26amp%3Bapp%3Dwebview%26amp%3Bcontext%3D%257BAppVersionMajor%253A16%252CAppVersionMinor%253A0%252CAppVersionBuild%253A11929%252CAppVersionUpdate%253A20002%257D%3C%2FA%3E%3C%2FLINGO-BODY%3E
Hursh Patel
Occasional Contributor

Hello,

 

Im trying to build an excel a sheet that auto hides rows based on a drop down selection

 

how do I hide rows automatically based on the drop down menu?

 

For instance - 

 

Hires

Row 1-10 viewable and it hides 11-20

 

Terminations

Row 11-20 viewable and hides row 1-10?

1 Reply
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies