Excel name list dropdown lost

J

JimBray

I have a workbook with 10-15 names that used to appear in a drop down
list and I was able to select a name and go directly to the array that
it defined. I hit some key by mistake and now I cannot see my dropdown
list.

I tried getting out of Excel and reloading the worksheet and that did
not work.

This list was created by clicking Insert/name/define. It was working
just fine until I hit some key. Any help on getting my list back would
be greatly appreciated.

Thanx Jim
 
M

Max

Tools/options/view and then check formula bar.

or just a mite shorter/quicker <g>:
Click View > Formula Bar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Need help modifying code 0
Best way to display Mulitple comboboxes and dropdown boxes for a userform 0
dependent, multiple variable, drop down list 2
How to create portable Excel applications? 2
Sum multiple worksheets and summary tab that would sum and count by rep name 0
Number of entries in DropDown List (ribbon) 0

Top