Solved

Excel 2007 -- Search ALL Tabs ?

Posted on 2010-09-10
2
394 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

718 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