+ Reply to Thread
Results 1 to 7 of 7

how to create search suggestion drop down list in mac excel

  1. #1
    Registered User
    Join Date
    06-11-2014
    Posts
    4

    how to create search suggestion drop down list in mac excel

    am looking for formula or method where i can create auto fill suggested drop down list ..i have very long list of items and most of them are repeated again and again but when i type in excel cell it only suggest recent active cell information ..i have tried data validation but i have to scroll down all the entire list to look for my item...so is it possible to make auto complete typing in an excel data validation list? am using macbook pro

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,899

    Re: how to create search suggestion drop down list in mac excel

    Take a look at Debra Dalgleish's site here:

    http://www.contextures.com/xlDataVal10.html

    she shows how to use a combo box which has the AutoComplete feature.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    06-11-2014
    Posts
    4

    Re: how to create search suggestion drop down list in mac excel

    thank you but problem is after i active combo box on worksheet... am not able to see any property after right click

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,899

    Re: how to create search suggestion drop down list in mac excel

    I don't know how a Mac differs from a PC, so I can't help you with that - sorry.

    Pete

  5. #5
    Registered User
    Join Date
    05-05-2015
    Location
    India
    MS-Off Ver
    2010
    Posts
    3

    Re: how to create search suggestion drop down list in mac excel

    see below link for autocomplete from dropdown list

    http://www.extendoffice.com/document...ocomplete.html

  6. #6
    Registered User
    Join Date
    05-05-2015
    Location
    India
    MS-Off Ver
    2010
    Posts
    3

    Re: how to create search suggestion drop down list in mac excel

    see below link for autocomplete in dropdownlist.

    http://www.extendoffice.com/document...ocomplete.html

  7. #7
    Registered User
    Join Date
    05-05-2015
    Location
    India
    MS-Off Ver
    2010
    Posts
    3

    Re: how to create search suggestion drop down list in mac excel

    Hi,

    http://www.contextures.com/xlDataVal10.html

    In the above link the autocomplete feature using combo box.

    But i need create a autocomplete feature in a cell.

    If anybody know pls share.

    Regards
    Prasanna

+ 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. How to create drop down list in Excel where each list item is based on two columns?
    By matkiros in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-11-2012, 08:50 AM
  2. Excel VBA Macro to create a drop down list
    By jeffgraser in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-23-2009, 08:08 PM
  3. How do I create a combo drop down list in Excel?
    By Ron in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-15-2005, 04:06 PM
  4. [SOLVED] How do I create a drop down list in Excel 2003
    By Lenny in forum Excel General
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM
  5. Is there a way to create a drop-down list of links in Excel?
    By t_boden in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-03-2005, 03:06 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