Link to home
Start Free TrialLog in
Avatar of Bert2005
Bert2005Flag for United States of America

asked on

How to create a drop-down list in Excel

Hi experts,

I am trying to create a drop-down list in Excel using the Help guide at the top of Excel. It seems relatively straight forward even if it does seem a little awkward. I am following all the steps, but I cannot get it to work exactly as it should.

I wonder, also, if part of it is that my spreadsheets always seem to have the column titles on row one and the first row of data on row two. Is that normal?

Thank you.

Bert

User generated image
User generated image
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

What version of Excel are you using?
my spreadsheets always seem to have the column titles on row one and the first row of data on row two. Is that normal?
Yes, very.
Avatar of Bert2005

ASKER

Hi Martin,

Thanks. Sorry, this is Excel 2013. I just got confused when I looked at the help guide. It shows the beginning of the process in the cell directly below the letter. But, I see there are no titles. I always use titles, and they always take up row 1. Which means the first patient in my practice will begin on row 2.

I guess I would think that if I were on row 100, it would be the 100th patient.

Bert
SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
That's a great idea!

This drop-down list shouldn't be so hard. First, I have tried to use DataValidation to clear entries, but when I start over, it continues to tell me there is already an entry with that name. I am not sure if I am selecting the cells correctly.

In Column C it as the heading:
Records (under this I put
Sent
Not sent

Maybe I am not selecting them correctly. I am clicking in the Sent field  and holding down shift and dragging down to the Not sent. Then right-clicking and choosing Define name. Then I am naming this. I have tried three times, so the three names I wish to use are already taken even though I am clearing them with the DataValidation step.

Maybe there is a better blog somewhere.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Much easier. Thanks. Suppose if I need 20 or 30, I will message you back!

Thanks for the help.
You're welcome and I'm glad I was able to help.

In my profile you'll find links to some articles I've written that may interest you.

Marty - Microsoft MVP 2009 to 2016
              Experts Exchange MVE 2015
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2015
I took a look. Will read them while I am working on this list. Thanks for the link.

Bert