Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 418
  • Last Modified:

Excel 2007 -- Search ALL Tabs ?

I currently do “CTRL & F” to find details in the current TAB ?

How can I do a “Global Find” in Microsoft Excel 2007 that searches all TABS, not just the active TAB ?
0
finance_teacher
Asked:
finance_teacher
2 Solutions
 
cyberkiwiCommented:
http://en.allexperts.com/q/Excel-1059/Search-Excel-sheets.htm

1) Go down to the bottom of the Excel window where you see the sheet tabs ("Sheet1" "Sheet2" etc.). Right-click on one of the sheet tabs.

2) In the shortcut menu that appears, click Select All Sheets.

You've now entered what's called "Group mode." Excel gives two visual cues to let you know you're in Group mode. First, the word "[Group]" appears in the title bar at the top of the screen. Second, the sheet tabs at the bottom of the screen turn white. (The currently active sheet is bolded.)

3) Press Ctrl/F to bring up the Find and Replace box.
0
 
Chris BottomleyCommented:
Or in find box, select option expansion and within select workbook.

CHris
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now