In Excel, do a search across multiple tabs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet with about 16 tabs of informtion in it. I want to find
different keyed in items on different tabs. Is there a way to do a cross tab
search ?
 
Try this

Right-Click one of the sheets and click "Select All Sheets" on the shortcut menu, then perform your search.

If any one of your sheets has more than one cell selected, this method won't
work correctly. After selecting all sheets, press Ctrl+A to select all
cells on all sheets to force the Find to search them all.

If you are using XL97, the "select all sheets" method will not work. You can
"Replace" across sheets, but not "Find".(Gord Dibben)

In Excel 2002-2003 , there is a "Within:" option in the Find/Replace dialog with a Workbook option.

You may want to try Jan Karel Pieterse's FlexFind (97-2003) at:
http://www.bmsltd.co.uk/MVP/Default.htm
 
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

Excel Search Function 1
Page Numbers and Multiple Tabs (Excel 2000) 2
How do I email a single spreadsheet tab in excel? 2
Printing multiple tabs 3
sheet with multiple tabs 3
security for tabs 5
how do i link the names of tabs in a workbook to a summary page? 1
Recover lost excel tabs/spreadsheets from workbook 2

Back
Top