how to group sheets to perform a find

  • Thread starter Thread starter wickwire
  • Start date Start date
W

wickwire

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...
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error Message - Macro to Unlink MS Queries from Workbook 0
Finding, grouping, then copy/paste to new sheet 15
hide multiple worksheets based on a formula value in one cell 1
Find the correct sheet then find a value on that sheet 8
Find a sheet within a workbook (If/Then/Else) 2
How to Protect the sheet, if few of the columns / rows are grouped 1
Macro to Compile Data from Different Sheets 2
Counting Duplicates on two sheets 2

Back
Top