Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-08-2021, 05:35 AM
DBenz DBenz is offline Find worksheet with a word within its name ? Windows 7 64bit Find worksheet with a word within its name ? Office 2010 32bit
Advanced Beginner
Find worksheet with a word within its name ?
 
Join Date: Dec 2014
Posts: 66
DBenz is on a distinguished road
Default Find worksheet with a word within its name ?

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
Reply With Quote
  #2  
Old 03-08-2021, 09:39 AM
Logit Logit is offline Find worksheet with a word within its name ? Windows 10 Find worksheet with a word within its name ? Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

How to search by worksheet name in Excel?

Learn Excel - Ctrl+F for Sheet Names? Podcast 2083 - YouTube
Reply With Quote
  #3  
Old 03-09-2021, 08:36 AM
wiganken wiganken is offline Find worksheet with a word within its name ? Windows 10 Find worksheet with a word within its name ? Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

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?
Reply With Quote
Reply

Tags
find, worksheet name

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find worksheet with a word within its name ? 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
Find worksheet with a word within its name ? How to summarise different worksheet to a summary worksheet samkiewhock Excel 1 09-06-2012 03:34 AM
Find worksheet with a word within its name ? Excel worksheet as OBJECT in WORD not displaying mohsin Word 1 03-27-2012 10:43 PM
Find worksheet with a word within its name ? Bad view when using Find and Find & Replace - Word places found string on top line paulkaye Word 4 12-06-2011 11:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:11 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft