Improve company productivity with a Business Account.Sign Up

x
?
Solved

Excel 2007 -- Search ALL Tabs ?

Posted on 2010-09-10
2
Medium Priority
?
427 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 1000 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 1000 total points
ID: 33645454
Or in find box, select option expansion and within select workbook.

CHris
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Excel allows various different methods to link Excel files to each other. This includes relative paths, mapped drives (or the local drive) and UNC paths. UNC paths are the least robust of the three.
This is a comprehensive review of a bundled Toolkit designed for use by IT Professionals and End Users to help Microsoft Outlook fans manipulate Outlook files and repair some common problems. Enjoy...
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

606 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