+ Reply to Thread
Results 1 to 11 of 11

Name Created in Name Manager Doesn't Show In Dropdown List

  1. #1
    Registered User
    Join Date
    05-13-2010
    Location
    Dallas, TX
    MS-Off Ver
    2003
    Posts
    97

    Name Created in Name Manager Doesn't Show In Dropdown List

    Hopefully this is easy. I'm wanting a created name to show in the dropdown list on a certain spreadsheet. The purpose of this name is to position myself to the last entry in the sheet in Column A.

    I went to name manager and created a name like this:

    =OFFSET('Office 365 Spam Processing'!$A$2121,0,0,COUNTA('Office 365 Spam Processing'!$A:$A)-1) and called it Blocked

    I started with A2121 because there were some cells above that that were blank.

    In any case, it takes the name but won't show it to me on the dropdown list of names when on that sheet. How do I get it to appear?

  2. #2
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    24,593

    Re: Name Created in Name Manager Doesn't Show In Dropdown List

    I don't understand what you mean by:

    In any case, it takes the name but won't show it to me on the dropdown list of names when on that sheet.

    Can you post the sheet (suitably anonymised), or a sample, showing the problem?
    Glenn



  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    8,423

    Re: Name Created in Name Manager Doesn't Show In Dropdown List

    As far as I know, there is no way of getting dynamic range names don't show in the drop-down.

  4. #4
    Registered User
    Join Date
    05-13-2010
    Location
    Dallas, TX
    MS-Off Ver
    2003
    Posts
    97

    Re: Name Created in Name Manager Doesn't Show In Dropdown List

    Quote Originally Posted by Glenn Kennedy View Post
    Can you post the sheet (suitably anonymised), or a sample, showing the problem?
    It's not showing here:

    And here's what I put in Name Manager:

    The uploaded jpeg images aren't showing. How do I add images?
    Last edited by AliGW; 10-18-2020 at 12:26 PM. Reason: Please don't quote unnecessarily! You can quote part of a post, but you do not need to quote all of it.

  5. #5
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    24,593

    Re: Name Created in Name Manager Doesn't Show In Dropdown List

    I don't want a picture.... please post the sheet.

    Unfortunately the attachment icon doesn't work at the moment. So,... instead click on Go Advanced (below the Edit Window) while composing your reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Make sure confidential information is removed first!!!!

  6. #6
    Registered User
    Join Date
    05-13-2010
    Location
    Dallas, TX
    MS-Off Ver
    2003
    Posts
    97

    Re: Name Created in Name Manager Doesn't Show In Dropdown List

    Hopefully it's attached.
    Attached Files Attached Files
    Last edited by AliGW; 10-18-2020 at 12:24 PM. Reason: PLEASE don't quote unnecessarily!

  7. #7
    Registered User
    Join Date
    05-13-2010
    Location
    Dallas, TX
    MS-Off Ver
    2003
    Posts
    97

    Re: Name Created in Name Manager Doesn't Show In Dropdown List

    Any ideas?

  8. #8
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    8,423

    Re: Name Created in Name Manager Doesn't Show In Dropdown List

    Dynamic named ranges do not show in the drop down & AFAIK there is no way to change that.

  9. #9
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    1,535

    Re: Name Created in Name Manager Doesn't Show In Dropdown List

    Are you getting confused - do you require data validation - just a thought
    torachan

  10. #10
    Registered User
    Join Date
    05-13-2010
    Location
    Dallas, TX
    MS-Off Ver
    2003
    Posts
    97
    No. Not data validation. I just want a quick way of getting to the bottom of column A. A column to the right has data in it that goes much farther than column A, so CTRL-End doesnít help. I can do CTRL-Shift-Down on column A, but I need to be beyond some spaces in the data. I want something like the safe name I have at the top, where I can choose a drop down and itíll go to the next opening, but that one isnít self adjusting like Iíd like it to be. Itís just a certain cell.
    Last edited by AliGW; 10-18-2020 at 12:25 PM. Reason: PLEASE don't quote unnecessarily!

  11. #11
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    8,423

    Re: Name Created in Name Manager Doesn't Show In Dropdown List

    One option is a macro, if your interested in that.
    Another is
    Ctrl End, followed by Home, followed by Ctrl Up Arrow.

+ 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] Changing Worksheets Using Dropdown List (not combo box) that doesn't include sheet names
    By firebird_richie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-02-2017, 11:48 PM
  2. Word Form Dropdown List Doesn't Appear
    By Ra21V12eN in forum Word Formatting & General
    Replies: 2
    Last Post: 08-22-2011, 03:50 PM
  3. How to sort dropdown list created though data validation tool?
    By chitian5057 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-11-2010, 10:32 PM
  4. Dropdown list created with dependent cell value
    By jchambers00 in forum Excel General
    Replies: 3
    Last Post: 03-04-2009, 10:26 AM
  5. VBA Created Pivot Table Doesn't Show Data
    By yawnzzzz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2008, 10:20 AM
  6. Created Dropdown list - How to change Font?
    By JonPugh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-20-2007, 07:24 AM
  7. Replies: 1
    Last Post: 06-29-2005, 08: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