+ Reply to Thread
Results 1 to 3 of 3

Direct Drop-Down List vs one linked to a table or other cells

  1. #1
    Forum Contributor
    Join Date
    05-16-2007
    Location
    USA
    MS-Off Ver
    MS Office 2016, Excel 2016
    Posts
    177

    Direct Drop-Down List vs one linked to a table or other cells

    Is there a way to create a drop-down list without creating a separate list that it must be linked to?

    I just want to have multiple values in a cell that can be viewed by clicking the cell or drop-down arrow, and also the ability to add/remove items from the list from the same cell.

    Example:
    I have a cell that shows the different printers assigned to the current user. Some users only have one printer assigned but others may have 2 or 3 etc. Instead of creating multiple cells labeled Printer 1, Printer 2, Printer 3, etc., I'd like to just list the printers in one cell via a quick drop-down or similar list, and of course, add or remove a printer if needed.

    I know this is possible in Access, but not sure about Excel.

  2. #2
    Registered User
    Join Date
    08-23-2018
    Location
    UAE
    MS-Off Ver
    2019 business
    Posts
    86

    Re: Direct Drop-Down List vs one linked to a table or other cells

    You can put them in as a comma separated list (on data validation select list and on source bar add your selection e.g)
    true,false
    yes,no
    printer 1, printer 2, printer 3
    without space
    Last edited by shj92922; 11-02-2018 at 02:45 PM.

  3. #3
    Forum Contributor
    Join Date
    05-16-2007
    Location
    USA
    MS-Off Ver
    MS Office 2016, Excel 2016
    Posts
    177

    Re: Direct Drop-Down List vs one linked to a table or other cells

    Quote Originally Posted by shj92922 View Post
    You can put them in as a comma separated list (on data validation select list and on source bar add your selection e.g)
    true,false
    yes,no
    printer 1, printer 2, printer 3
    without space
    Yeah, I just noticed that option and it does work, though a bit awkward. Would be nice if I could just right click the drop-down button to add or remove items without needing to go up to the ribbon and make the changes.

+ 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. [SOLVED] Auto-update cells based on a cell drop-down list and a table
    By Castillb in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-27-2015, 07:19 PM
  2. Drop Down List with Linked Column
    By paulofabingdon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2014, 02:53 PM
  3. macro to save specific sheet as pdf direct to folder linked via cell
    By sdts in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-17-2012, 05:45 AM
  4. Word drop down list linked with excel
    By Didec in forum Word Formatting & General
    Replies: 1
    Last Post: 09-23-2011, 02:03 PM
  5. Input data automatically linked to drop down list
    By Greybeard101 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2011, 11:23 AM
  6. linked drop down list boxes and external source
    By haggisns in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2010, 03:07 PM
  7. Updating of cell linked to drop-down list
    By zalcjm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2006, 04:40 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