Find worksheet with a word within its name ?

DBenz · #1 03-08-2021, 05:35 AM

Hi,

Excel 2010
If I do a find clicking in the top left corner of the first sheet then ctrl F and options advanced and select within workbook, enter *word* (word being the word I need to find) it says nothing found, yet I know I have a sheet on this subject with that word and would have used the word in the sheet.
Eventually I find the sheet, the word I was using is in the sheet tab title but not on the sheet.
I need to find sheets and not just content within the sheet, this is happening often.
How can I get ctrl F to also find the sheet name using *word* ?

I am amazed Msoft dont allow a worksheet name find in this essential process.

Cheers

DBenz

Logit · #2 03-08-2021, 09:39 AM

How to search by worksheet name in Excel?

Learn Excel - Ctrl+F for Sheet Names? Podcast 2083 - YouTube

wiganken · #3 03-09-2021, 08:36 AM

Clicking on the top left hand corner selects everything in that sheet and therefore limits the search to that sheet. Have you tried not clicking on the top left hand corner so that the 'Find' command will search all sheets?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Link UserForm checkbox to corresponding shape on one worksheet and copy to 'template' worksheet	kiwimtnbkr	Excel Programming	23	10-08-2020 02:32 AM
Import Excel worksheet into Word with VBA	trevorc	Word VBA	2	12-05-2018 11:30 PM
How to summarise different worksheet to a summary worksheet	samkiewhock	Excel	1	09-06-2012 03:34 AM
Excel worksheet as OBJECT in WORD not displaying	mohsin	Word	1	03-27-2012 10:43 PM
Bad view when using Find and Find & Replace - Word places found string on top line	paulkaye	Word	4	12-06-2011 11:05 PM