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.

A simple excel search and display

Discussion in 'Business Applications' started by williamc, Nov 12, 2004.

Thread Status:
Not open for further replies.
  1. williamc

    williamc Thread Starter

    Jul 19, 2004
    This should be simple, I just cant figure it out. I have an excel document that needs to be searched via column 1. The result it finds needs to be displayed on its own.

    Ctrl+F will find the item, but the powers that be want it displayed without the other records around it. Any idea on how to do this? Thanks.

  2. johnni


    Dec 16, 2003
    To do this is to use Data, Filter, Auto Filter.

    If you only want to search column1 (A), and assuming it has a header name, left click on the name and drag down so rows A1 and A2 are highlighted. Go to the above and click on Auto Filter; a box with an arrow will appear at the right of A1; click the box and if you see what you are looking for in the list just click it; otherwise select Custom, and in the right pane (on a level with Equals) type either the entire phrase you are looking for, OR if you only want to see one name (e.g. computer) amongst other variables type *computer*.

    Click OK to see only the results for that phrase/name. To see everything again click the A1 arrow, press Home (or click All) and click OK.
    While the results are being displayed you can press Ctrl+A to select them all and copy to a blank sheet.

  3. BigBopper


    Nov 12, 2004
    Ah-ha! What a stroke of luck...i need to do this for a job at work too!

    Thx for the suggestion! :D
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/295575