+ Reply to Thread
Results 1 to 2 of 2

Right Click - Pick from Drop Down List problem

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

    Question Right Click - Pick from Drop Down List problem

    Hi there,
    I have spreadsheets which I have fields that need to be populated. Year|Month|Date|Detail|Expense|Category|Sub-Category
    I bring information in from other sources (like credit card records) to populate all except the Category and Sub-Category fields
    If the spreadsheet is not filtered, I can select a cell and right click then using "Pick from Dropdown List" I can plug in the appropriate Category, and do the same on the Sub-Category
    If the spreadsheet is filtered to just the new year I'm entering data for, the available items to choose from are not visible or at most only those entered in the visible cells are, so it becomes far more difficult to populate the necessary fields, and the problem is I've filtered to those records on which those fields are currently blank so that I can populate them.
    Is there a way to force Excel to display the options for picking from the dropdown list for the rows that aren't visible so a selection can be made in the visible rows?
    Thanks in advance.

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Essex, UK
    MS-Off Ver
    various
    Posts
    2,582

    Re: Right Click - Pick from Drop Down List problem

    you might consider applying a Data Validation List to your range, instead

    see: https://www.contextures.com/xldataval01.html

+ 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. Drop down list - how to make the makro pick a certain value in the list
    By KatheR in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-02-2021, 02:36 AM
  2. [SOLVED] Pick from drop down, populate list of 3
    By Jason G in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-28-2017, 02:12 PM
  3. Pick from Drop-down List
    By e045006 in forum Excel General
    Replies: 2
    Last Post: 11-01-2011, 02:23 PM
  4. RE: how do i get a drop down pick list in a cell
    By bpeltzer in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-02-2006, 11:30 AM
  5. how do i get a drop down pick list in a cell
    By andrew openshaw in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-02-2006, 11:30 AM
  6. pick items:Drop Down List
    By JackR in forum Excel General
    Replies: 1
    Last Post: 02-21-2006, 05:30 PM
  7. Pick from a drop-down list
    By Matilda in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-20-2006, 04:10 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