Search on excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2018929%22%20slang%3D%22en-US%22%3ESearch%20on%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2018929%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20so%20I%20have%20about%20200%20folders%20on%20my%20excel%20and%20want%20to%20search%20for%201%20of%20the%20folders%20or%20''tabs''%20so%20I%20dont%20have%20to%20scroll%20through%20all%20of%20them.%20But%20the%20search%20doesnt%20work.%20I%20select%20all%20''tabs'%20and%20then%20press%20search%20type%20in%20the%20name%20correct%20but%20it%20still%20says%20not%20find.%20Why%20is%20this.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2018929%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2018963%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20on%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2018963%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F913118%22%20target%3D%22_blank%22%3E%40saskiasn21%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20recommend%20following%20the%20advice%20from%20this%20%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fmsoffice_excel-mso_winother-mso_2010%2Ftab-names-in-excel%2F0358b46c-b254-40a4-bba9-e1c7a5eca78d%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Epost%3C%2FA%3E%3C%2FP%3E%3CP%3EThere%20is%20no%20current%20way%20to%20search%20by%20sheet%20names%2C%20however%2C%20you%20can%20create%20a%20hyperlink%20function%20in%20your%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi so I have about 200 folders on my excel and want to search for 1 of the folders or ''tabs'' so I dont have to scroll through all of them. But the search doesnt work. I select all ''tabs' and then press search type in the name correct but it still says not find. Why is this. 

1 Reply

@saskiasn21 

I recommend following the advice from this post

There is no current way to search by sheet names, however, you can create a hyperlink function in your workbook.