+ Reply to Thread
Results 1 to 4 of 4

Drop-down menu with the exclusion of empty cells

  1. #1
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    Drop-down menu with the exclusion of empty cells

    Good evening, I would like to ask you a question:
    do you know if there is a formula to insert in data validation
    that shows you a drop-down menu without empty lines?
    Of course without having another service column
    Thanks
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,145

    Re: Drop-down menu with the exclusion of empty cells

    Not that I'm aware of... but who knows, someone else might.

    As far as I know, you will need a helper column (somewhere) to create a blank-free list.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    Re: Drop-down menu with the exclusion of empty cells

    I thank you,
    I wait to see if another idea comes up.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,363

    Re: Drop-down menu with the exclusion of empty cells

    Cannot be done without creating a new "helper" column (as per Glenn's reply).
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. Replies: 1
    Last Post: 02-07-2013, 11:03 AM
  2. Replies: 3
    Last Post: 01-31-2013, 06:22 PM
  3. [SOLVED] I cant work out how to create a drop down menu that relates to another drop down menu
    By louise2613 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-18-2012, 01:49 PM
  4. Replies: 2
    Last Post: 01-30-2009, 04:23 PM
  5. Drop down menu for multiple cells! AHH!
    By dekken in forum Excel General
    Replies: 6
    Last Post: 01-06-2009, 08:57 AM
  6. Drop Down menu & linked cells
    By darken99 in forum Excel General
    Replies: 4
    Last Post: 05-30-2007, 03:44 PM
  7. [SOLVED] Drop down menu-How do you produce a drop down menu in a single cell in Excel
    By Freddo in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-04-2006, 04:35 AM
  8. Creating a drop down like menu for row of cells?
    By the_OM in forum Excel General
    Replies: 2
    Last Post: 06-01-2005, 06:05 PM

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