Forum Discussion
BillHull
Oct 19, 2022Copper Contributor
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