1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Searching Workbook

Discussion in 'Business Applications' started by Kolias, Apr 8, 2015.

Thread Status:
Not open for further replies.
Advertisement
  1. Kolias

    Kolias Thread Starter

    Joined:
    Apr 8, 2006
    Messages:
    374
    I have an Excel 2013 workbook with 26 sheets which include various business contacts. Each worksheet represents an alphabet letter and all columns for each sheet are identical (kind of a typical address book)

    Is it possible to search the whole workbook for a particular contact or I have to search each sheet?
     
    Kolias, Apr 8, 2015
    #1
  2. valis

    valis Moderator

    Joined:
    Sep 24, 2004
    Messages:
    77,588
    Right click any tab > select all sheets > ctrl f.
     
    valis, Apr 8, 2015
    #2
  3. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    Just type Ctr + F
    In the dialog box you press the button Options and there you can select Within: Sheet or Workbook
    Depending on your criteria there are two checkboxes, Match Case and Match entire cell contents.
    This speaks for itsself
     
    Keebellah, Apr 8, 2015
    #3
  4. Kolias

    Kolias Thread Starter

    Joined:
    Apr 8, 2006
    Messages:
    374
    Very nice tips and work well, thanks
     
    Kolias, Apr 8, 2015
    #4
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1146251

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice