Forum Discussion

Copper Contributor

Jul 30, 2019

Solved

Search find in excel

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 ...

excel

JKPieterse
Jul 30, 2019
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?

JKPieterse

Silver Contributor

Jul 30, 2019

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?

calgar1700

Copper Contributor

Aug 01, 2019

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

JKPieterse
Silver Contributor
Aug 01, 2019
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).