excel spreadsheet Search include sheet names
hi,
I have about 50 sheets in my excel with different headings for each sheet. When i search by selecting Options and then Within workbook it is searching only the content not the sheet names.
lets say my excel name is world.xls
i have different sheets like usa, uk, australia, india
usa sheet i ahve state names like georgia, michigan etc
if i search on usa by Options and then Within workbook it is searching only the content not the sheet names and i never get search results which i am looking(like usa state names)
how to include sheet names also in the search.
please advise
I have about 50 sheets in my excel with different headings for each sheet. When i search by selecting Options and then Within workbook it is searching only the content not the sheet names.
lets say my excel name is world.xls
i have different sheets like usa, uk, australia, india
usa sheet i ahve state names like georgia, michigan etc
if i search on usa by Options and then Within workbook it is searching only the content not the sheet names and i never get search results which i am looking(like usa state names)
how to include sheet names also in the search.
please advise
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You cannot make excel do that search as part of the built in search. You can write code to search e.g. specifically worksheet names. You would put it in a standard module (code). You can execute it directly from the immediate pane, or by assigning the code name to a button, shape or the ribbon.
It might be easier to understand your needs if you can tell us WHY you need to search the sheet names?
It might be easier to understand your needs if you can tell us WHY you need to search the sheet names?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Are you aware that you can get a full list of Sheet Names with a Right Click on the sheet navigator arrows at the bottom left of the screen, to the left of the left most visible sheet.
The sheets are listed in the same order as in the workbook, select one in the list and click OK to go to that sheet.
i am not aware can you please put a screenshot if possible?
ASKER
is there is a way i can sort sheet names?
ASKER
i see at left bottom corner if i right click al lsheet names with Activate option to activate particular sheet
Author appeared to appreciate the suggestion I made as conversation continued on that option.
ASKER