how to group sheets to perform a find
 

I need to remove duplicate names in about 8 or 9 worksheets. How can I
perform a search without having to go into each sheet? I don't know how to
group...

how to group sheets to perform a find
 

You can CTRL-Click the tab you want to search (this will do a multiple
select of sheets) then do the search.

Charlie
www.openerconsulting.com

wickwire;179045 Wrote:
I need to remove duplicate names in about 8 or 9 worksheets. How can
I
perform a search without having to go into each sheet? I don't know
how to
group...


--
Charlie
------------------------------------------------------------------------
Charlie's Profile: http://www.thecodecage.com/forumz/member.php?userid=89
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=49511

how to group sheets to perform a find
 

You don't need to group the sheets to search within "workbook" in the search
options.

Grouping is done by selecting one sheet tab then CTRL + ckick on any others
you want in the group.

Or by select then SHIFT+ click to group a continguos group of sheets.

Or right-click on a tab and "select all sheets"

BTW...........if you type "group sheets" in the Help dialog then "select
sheets" you will see all the info you need about grouping sheets.


Gord Dibben MS Excel MVP

On Mon, 12 Jan 2009 13:23:01 -0800, wickwire
wrote:

I need to remove duplicate names in about 8 or 9 worksheets. How can I
perform a search without having to go into each sheet? I don't know how to
group...