+ Reply to Thread
Results 1 to 5 of 5

Drop down list to show title of table.

  1. #1
    Registered User
    Join Date
    02-13-2019
    Location
    UK
    MS-Off Ver
    2016
    Posts
    3

    Drop down list to show title of table.

    Currently when making a drop down list, on the worksheet the cell with the list in is blank and will only display once an item from the list is selected.

    The 'Entry Form' I am creating does not have room for individual headers for each of the lists I am creating......

    How do I pre-fill the list with text indicating its purpose..
    I.e. The list could have three name: Jon, Jack and Joe. The blank cell with the list in, needs to display the word 'Name'.

    I have searched and have been unable to find anything .

    Many thanks for looking.

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Drop down list to show title of table.

    This should help:
    https://www.extendoffice.com/documen...ted-value.html
    Click the * to say thanks.

  3. #3
    Registered User
    Join Date
    02-13-2019
    Location
    UK
    MS-Off Ver
    2016
    Posts
    3

    Re: Drop down list to show title of table.

    Wow! That was quick. Thank you, I'll give it a go.
    Appreciate the help.

  4. #4
    Registered User
    Join Date
    02-13-2019
    Location
    UK
    MS-Off Ver
    2016
    Posts
    3

    Re: Drop down list to show title of table.

    The first list works great. the second list (in the next cell to the right of the first list) just displays the formula and not the text.

    I have referenced the same blank cell as the previous list. i.e. C6 is:Blank , C7 is: =IF(C6="","-ListOne") and C8 is: =IF(C6="","-ListTwo")

    Very confused

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,422

    Re: Drop down list to show title of table.

    Hello Pacsboys and Welcome to Excel Forum.
    It may help us to help you if you would upload a sample of the spreadsheet that isn't properly displaying the default values for the drop down lists.
    To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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: 9
    Last Post: 05-02-2017, 01:08 PM
  2. Filter table based on drop down list and show on another sheet
    By ajupillai in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2016, 04:50 PM
  3. Can you title a drop down list?
    By Excel_1234 in forum Excel General
    Replies: 2
    Last Post: 04-09-2016, 05:33 PM
  4. [SOLVED] Show total for pie chart from a pivot table in title
    By kaleonard08 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-25-2016, 02:46 PM
  5. Replies: 1
    Last Post: 07-16-2015, 05:46 AM
  6. Show main title in chart table
    By sarinky in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-05-2015, 09:33 AM

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