G Guest Feb 20, 2004 #1 Does anyone know how to create drop down menus in excel? e.g. to be able to click on a heading which produces a list and then select from the list.
Does anyone know how to create drop down menus in excel? e.g. to be able to click on a heading which produces a list and then select from the list.
B Bob Phillips Feb 20, 2004 #2 Mark, You probably want Data Validation (from the little info given). Check out help and Debra Dalgleish's site at http://www.contextures.com/xlDataVal01.html -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) Mark said: Does anyone know how to create drop down menus in excel? e.g. to be able Click to expand... to click on a heading which produces a list and then select from the list.
Mark, You probably want Data Validation (from the little info given). Check out help and Debra Dalgleish's site at http://www.contextures.com/xlDataVal01.html -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) Mark said: Does anyone know how to create drop down menus in excel? e.g. to be able Click to expand... to click on a heading which produces a list and then select from the list.
N nytmare Feb 20, 2004 #3 You might try: - select the column(s) you want to filter. - then click on Data/Filter/AutoFilter I've found using the AutoFilter feature is sensitive to blank row though... so watch out for them. Mar
You might try: - select the column(s) you want to filter. - then click on Data/Filter/AutoFilter I've found using the AutoFilter feature is sensitive to blank row though... so watch out for them. Mar
