how to create a drop down list in excel for mac

Create A Drop Down List In Excel For Free By Whitelisting

She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies.

Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions.

Double-clicking the file on your computer will open it in Microsoft Excel.

For this example, well add two new values to a drop-down list in column A.

Type each additional option into its own cell at the bottom of the current list.

Its to the right of the Refers to box at the bottom of the Name Manager.

Its at the top of your sheet (the box you collapsed earlier).

Its the cell at the top of the list that contains a downward-pointing arrow button.

Its in the Data Tools group in the ribbon at the top of Excel.

Be sure to select the old values as well as the ones you just added.

Its in the Data Tools section of the ribbon bar at the top of Excel.

Amid the current public health and economic crises, when the world is shifting dramatically and we are all learning and adapting to changes in daily life, people need wikiHow more than ever.

By continuing to use our site, you agree to our cookie policy.

Create A Drop Down List In Excel For Free By Whitelisting

Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker.

If you really cant stand to see another ad again, then please consider supporting our work with a contribution to wikiHow.

How To Create A Drop Down List In Excel For Mac