Forum Discussion

BillHull's avatar
BillHull
Copper Contributor
Oct 19, 2022

using "ctrl F " and changing how it is displayed

I use 700 plus sheets to monitor stock inventory,  using "ctrl f " as my search aid, i get a list of all the sheets that contain the searched value, the list  gives cell location ,sheet location  etc .

Does excel allow me to change how this list appears , eg. to report in the list a cell value that i might be able to use to identity the sheet i am interested in  .

I like the list the search "ctrl f "gives ,as it then allows me to select the right value which in turn takes me to the sheet i am looking for.

or is there a better way to do this ,

cheers

Bill

Resources