SOLVED
Home

Search find in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-778915%22%20slang%3D%22en-US%22%3ESearch%20find%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-778915%22%20slang%3D%22en-US%22%3E%3CP%3Eusig%20search%20function%20on%20menu%20%2C%20it%20doesnt%20show%26nbsp%3B%20the%20doc%20im%20working%20on%20as%20the%20object%20of%20search%20..%20how%20to%20get%20searching%20in%20current%20doc%20%3F%3C%2FP%3E%3CP%3Ealso%2C%20i%20cant%20get%20search%20t%20o%26nbsp%3B%26nbsp%3B%20appear%20in%20quick%20access%20menu%20..%20it%20seems%20to%20have%20disappered%20every%20time%20i%20try%20to%20add%20it%20in%20via%20customise%20ribbon%20...%3C%2FP%3E%3CP%3Ealso%20%2C%20a%20series%20of%20numbered%20boxes%20(%20small%20)%20appear%20in%20top%20left%20of%20s%20sheet%20%2C%2C%20what%20is%20this%20and%26nbsp%3B%20how%20to%20get%20rid%20of%20it%20...%3F%20its%20long%20column%20in%20grey%20at%20left%20screen%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3CP%3Ecalgar%201700%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eth%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-778915%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779144%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20find%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779144%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F384239%22%20target%3D%22_blank%22%3E%40calgar1700%3C%2FA%3ESearch%20always%20searches%20in%20the%20active%20workbook.%20If%20you%20select%20more%20than%20one%20cell%2C%20it%20searches%20within%20those%20cells%20only.%3C%2FP%3E%0A%3CP%3EAdding%20Find%20the%20the%20QAT%20works%20for%20me.%20I%20click%20the%20binoculars%20on%20the%20Home%20tab%2C%20right-click%20Find%20and%20choose%20Add%20to%20Quick%20Access%20Toolbar.%3C%2FP%3E%0A%3CP%3EI'm%20not%20sure%20what%20you%20mean%20by%20numbered%20boxes%2C%20can%20you%20share%20a%20screen-shot%20of%20that%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-783692%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20find%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-783692%22%20slang%3D%22en-US%22%3Ewhat%20does%20%22%20find%20the%20the%20QAT%20%22%20mean%20%3F%3CBR%20%2F%3Ethanks%20for%20reply%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-783725%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20find%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-783725%22%20slang%3D%22en-US%22%3E%3CP%3EHmm%2C%20there's%20a%20typo%20and%20some%20jargon%20in%20there.%20I%20wanted%20to%20write%20%22Adding%20Find%20to%20the%20QAT%22.%20QAT%20means%20Quick%20Access%20Toolbar%2C%20the%20toolbar%20at%20the%20top%20of%20Excel%20(or%20below%20the%20ribbon%2C%20it%20can%20be%20in%20either%20of%20those%20places).%3C%2FP%3E%3C%2FLINGO-BODY%3E
calgar1700
Occasional Contributor

usig search function on menu , it doesnt show  the doc im working on as the object of search .. how to get searching in current doc ?

also, i cant get search t o   appear in quick access menu .. it seems to have disappered every time i try to add it in via customise ribbon ...

also , a series of numbered boxes ( small ) appear in top left of s sheet ,, what is this and  how to get rid of it ...? its long column in grey at left screen

thanks

calgar 1700

 

 

th

3 Replies
Highlighted
Solution

@calgar1700 Search always searches in the active workbook. If you select more than one cell, it searches within those cells only.

Adding Find the the QAT works for me. I click the binoculars on the Home tab, right-click Find and choose Add to Quick Access Toolbar.

I'm not sure what you mean by numbered boxes, can you share a screen-shot of that?

Highlighted
what does " find the the QAT " mean ?
thanks for reply

Highlighted

Hmm, there's a typo and some jargon in there. I wanted to write "Adding Find to the QAT". QAT means Quick Access Toolbar, the toolbar at the top of Excel (or below the ribbon, it can be in either of those places).

Related Conversations
Insert an image in Excel header
mat74 in Excel on
1 Replies
DAX Powerpivot - How to solve this problem in PowerPivot
kayyeah11 in Excel on
0 Replies
IF statements and conditional formatting
clare1981 in Excel on
1 Replies
Reverse numbers and characters in worksheet
David_Gerrior in Excel on
1 Replies
Sumifs
Jsbluemoon82 in Excel on
4 Replies
Excel formula similiar to texjoin
Carlo74 in Excel on
1 Replies