Solved

Excel 2007 -- Search ALL Tabs ?

Posted on 2010-09-10
2
369 Views
Last Modified: 2012-05-10
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
Comment
Question by:finance_teacher
2 Comments
 
LVL 58

Accepted Solution

by:
cyberkiwi earned 250 total points
ID: 33645419
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
 
LVL 59

Assisted Solution

by:Chris Bottomley
Chris Bottomley earned 250 total points
ID: 33645454
Or in find box, select option expansion and within select workbook.

CHris
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Looking for macro to do version saving of workbooks in Excel 2016. 6 38
Hiding column macro 10 28
Excel case statements 3 24
NEED TO UPDATE DATA IN EXCEL 18 32
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now