Lists

E

ExcelBob

I've created a master sheet for inputting data throughout the year an
want to do a drop down list so that only one month is shown at a time.

Firstly, how do I display a pick list in month order (April thru t
March) as opposed to alphabetical order?

Secondly, can it be set up so that it is not possible for the user t
show 'All' at once. Therefore only allowing them to pick one month a
a time..?

Thanks
ExcelBo
 
G

Guest

Hi ExcelBob. I typed January-December in a column and used Data Validation,
list and selected the cells. In the dropdown list, the months were shown as
entered in the column and you can only select one at a time. HTH
 

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

Here we go again.... 10
Eliminate duplicate values in drop down list 1
=TODAY() and HLOOKUP - help needed 2
Automatically shift chart data range: redux 6
months on separate tabs 1
Rolling Budget 3
REPLACE FUNCTION!!!!!! 3
Multiple dependent combo boxes 1

Top