Create a drop-down list, error "a named range you specified can not be found"

Anonymous
2016-07-26T17:25:06+00:00

Original title: Drop down list

while trying to create a drop down list when I click on Input message tab I keep getting a message that says " a named range you specified can not be found" please help

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Anonymous
    2016-07-26T21:41:05+00:00

    Hi Todd,

    I suggest you to kindly refer to the thread given below which discusses about the similar issue. Check if it helps:

    http://answers.microsoft.com/en-us/mac/forum/macoffice2008-macexcel/how-do-i-make-drop-down-list-boxes/1b96ba45-4ce5-4567-9095-77e2cc6a5946

    Hope this helps. Do let us know the result. We’ll be happy to assist you further.

    Thank you.

    0 comments No comments
  2. Anonymous
    2016-08-03T13:36:41+00:00

    Still does not work..

    0 comments No comments
  3. Anonymous
    2016-08-04T21:56:24+00:00

    Hi,

    I suggest you to kindly go through the Microsoft article below and check if you are able to create a drop down list in Excel:

    https://support.office.com/en-us/article/Create-a-drop-down-list-in-Excel-2016-for-Windows-f63c0712-8d46-4afc-92d7-afd67cad0b1d

    Hope this information helps. Do let us know for further assistance.

    Thank you.

    0 comments No comments