Solved

Excel 2007 -- Search ALL Tabs ?

Posted on 2010-09-10
2
366 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
Comment Utility
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
Comment Utility
Or in find box, select option expansion and within select workbook.

CHris
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Outlook Free & Paid Tools
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

771 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

13 Experts available now in Live!

Get 1:1 Help Now