Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    London, Gtr London, England
    Posts
    100
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Searching multiple sheets (Excel 2000 v9.0)

    We hold contact data on an Excel file with multiple tabs at the bottom for different sections in the organistation. As I do not know my way around, yet, is there some way to use the Edit/Search facility to look at all the sheets which are tabbed?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Searching multiple sheets (Excel 2000 v9.0)

    Try selecting more than one sheet by clicking on one tab, then Shift+clicking on another one. Find should then work on all selected sheets.

  3. #3
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    London, Gtr London, England
    Posts
    100
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Searching multiple sheets (Excel 2000 v9.0)

    Hi, Hans,

    As usual, the right solution!

    Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •