+ Reply to Thread
Results 1 to 3 of 3

'Find' function for selected column(s)

  1. #1
    Registered User
    Join Date
    06-27-2013
    Location
    c
    MS-Off Ver
    Excel 2003
    Posts
    18

    'Find' function for selected column(s)

    When I do control + F to find a value, it searches all the spreadsheet. Is there a way to search only in a selected column/s?

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: 'Find' function for selected column(s)

    In Find Dialogue box click options>>Under Within>>Select Sheet instead of workbook and select the particular column and do the search.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: 'Find' function for selected column(s)

    or, click on that column or range, then CTRL F, it will restrict the search to just that range
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Find the value selected in listbox in a table and paste a value one column over
    By bcn1988 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-25-2012, 06:17 PM
  2. Find Duplicates and move a selected cell to another column
    By scottie72 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-24-2012, 09:33 AM
  3. How to find 1st letter in column that meets selected macro button A - Z
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 01-29-2012, 10:22 PM
  4. Warning if using find function over selected range
    By Jack Bauer in forum Excel General
    Replies: 3
    Last Post: 06-09-2009, 04:41 AM
  5. Trying to find max date in 1 column for selected text in another column
    By foxguy in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 04-12-2009, 11:54 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1