How to Search for word in the Entire Workbook

Gord Dibben

Posts: n/a

XL97 will not do a search over grouped sheets.

However, it will do a replace over grouped sheets.

Gord Dibben Excel MVP

On Mon, 4 Jul 2005 18:58:42 +0100, "Nick Hodge"
wrote:

In versions before 2002 (XP) group the sheets (Ctrl + click tabs
(non-contiguous) or shift + click tabs (contiguous)) and then do your search

The option to search the entire book is built into Excel XP and 2003

You might also try Jan Karel's flexfind add-in here

http://www.jkp-ads.com/OfficeMarketPlaceFF-EN.htm

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I print an entire workbook w/diff orientatns to Adobe PDF?	Sus	Excel Discussion (Misc queries)	0	June 21st 05 06:05 PM
Can I AutoFilter an entire workbook?	Matrix015	Excel Discussion (Misc queries)	0	January 18th 05 02:51 PM
can i make a formula to search keywords in a excel workbook?	gorillayam	Excel Worksheet Functions	0	January 15th 05 02:25 AM
Search should highlight entire row in Excell in red	samuel	Excel Discussion (Misc queries)	5	December 27th 04 11:49 PM
print entire workbook default	KatGat01	Excel Discussion (Misc queries)	3	December 14th 04 10:12 PM

All times are GMT +1. The time now is 04:40 AM.

Menu

About Us