Can You Create a Dropdown List in OneNote?

No—OneNote does not provide a native dropdown-list control that readers can open and use to choose one value from a menu. You can still get similar results by linking to an Excel dropdown, using a checklist or table for simple choices, or collecting responses with a form.

What OneNote Can and Cannot Do

OneNote is designed for notes, pages, and organizing information, rather than for building interactive forms. Its pages can contain typed text, tables, checklists, tags, links, and inserted files, but a standard OneNote page does not offer a form field with a built-in arrow and selectable options. Typing a list of choices onto a page does not make it interactive, and a OneNote table cell does not become a dropdown simply because you add possible values nearby.

This distinction matters when deciding what to build. A dropdown normally limits a user to a defined set of answers, such as Open, In progress, and Done. It can help keep entries consistent and, in a spreadsheet, can support filtering and analysis. OneNote can record those answers, but it does not enforce a set of allowed values on an ordinary note page.

OneNote can still be useful as the place where instructions, meeting notes, or project information live. The practical question is whether people need to select a value inside the note itself, or whether it is enough to keep a link to a separate tool that handles the selection.

Best Workaround: Use an Excel Dropdown

For a genuine selectable list, Excel is usually the closest fit. Excel has data validation that can show a dropdown in a cell and, if configured, warn users when they enter a value that is not on the list. You can keep the workbook alongside your OneNote notes or link to it from the relevant page. The dropdown then belongs to Excel, not to OneNote.

In Excel for Microsoft 365 on Windows, create the list this way:

Enter the allowed choices in a column, such as Draft, In review, and Approved.
Select the cell or cells where users should choose a value.
Go to Data > Data Validation.
On the Settings tab, choose List under Allow. Set the Source to the cells containing your choices, or enter a short comma-separated list.
Make sure the in-cell dropdown option is enabled, review the input message or error alert if useful, and select OK.

For instance, a project tracker might have one row per task and a Status column with the three choices Draft, In review, and Approved. A user can choose a status in Excel, while the OneNote page can explain what each status means and link to the tracker. Using cells as the source is easier to maintain when options change than editing a comma-separated list in the validation dialog.

Excel for the web also supports data validation dropdowns, although the dialog and available controls can differ slightly from the Windows desktop app. Excel for Mac has data validation as well, accessed from the Data tab or Data menu depending on the current interface. Because OneNote and Excel features can vary by platform and update, check the workbook in the version your collaborators will use before relying on a particular layout.

How to Keep the Workbook Connected to Your Notes

The simplest arrangement is to save the Excel workbook in a location your intended readers can access, such as a shared OneDrive or SharePoint location, and add a link to it on the OneNote page. In OneNote, place the link near the instructions or project notes so readers understand which workbook to open. A clear label such as “Choose a task status in the project tracker” is more helpful than an unexplained file name.

Some OneNote desktop versions also let you insert an Excel spreadsheet object through Insert > Spreadsheet. That can be convenient when you want spreadsheet content represented on the page. However, an inserted spreadsheet is still an Excel object; it does not turn the surrounding OneNote page into a form. The way you open or edit the object can vary by OneNote version, and the embedded copy may not behave like a live shared workbook. Confirm where edits are saved and whether collaborators can access them before using it as a team workflow.

If several people need to update the same choices, a shared workbook link is generally easier to explain and manage than multiple copies attached to notes. Avoid keeping separate versions in different notebooks unless you have a clear process for deciding which one is current. Otherwise, someone may update an old copy while the team reads another.

Simple Choices: Use a Checklist or Table

If the goal is only to mark progress or make a choice visible, a OneNote checklist may be enough. Add a to-do tag to each line—for example, “Call supplier,” “Request estimate,” and “Approve order”—and mark the relevant item complete. This works well for tasks because the user is checking items off, not selecting a single value from a controlled list.

A table can also make a small set of options easier to read. For example, a meeting note could have columns for Topic, Owner, and Decision, with the chosen decision typed into the last column. This is quick and flexible, but it does not restrict entries: one person might type “Approved,” another “Yes,” and another “Looks good.” Use a table when readability matters more than data consistency. Use Excel validation when a consistent, selectable answer matters.

OneNote tags and checkboxes should not be mistaken for dropdowns. A checkbox represents a completion state, and a tag labels a piece of note content. Neither supplies a menu of mutually exclusive values that OneNote validates for you.

When a Form Is a Better Fit

If people need to submit answers rather than edit a shared tracker, a form may be more appropriate. A form tool can present questions and choice options, then collect submissions in a structured way. This can be useful for a meeting poll, a request intake process, or a recurring status update where participants should not change one another’s entries.

OneNote is often useful for linking to a form and keeping its purpose, instructions, and related notes together. Whether a form can be inserted or displayed directly in a particular OneNote app depends on the available integrations and account setup; a reliable fallback is to include a normal link and let respondents open it in a browser. Choose a form for collecting separate responses, and choose an Excel workbook when people need to work with a shared grid of records.

Before distributing either option, check permissions. A link that works for its creator may not work for every reader if the workbook or form is restricted to a different account or organization. Test it with the kind of account your audience will use.

Choosing the Right Approach

The best substitute depends on what the dropdown is meant to accomplish. A short decision guide can help:

Need a real menu and consistent values: use an Excel data-validation list and link to the workbook from OneNote.
Need people to submit answers separately: use a form with choice questions and place its link in the note.
Need to mark tasks complete: use OneNote to-do tags or checkboxes.
Need to record a small decision for reference: use a OneNote table and type the decision.

Consider who will edit the information, whether answers must be restricted, how many records you expect, and whether you need to sort or report on results. A few choices in a personal note rarely justify a separate workbook. A team tracker with many rows, recurring updates, or reporting needs is a stronger case for Excel. A survey with one response per person is usually better handled as a form.

Common Problems and Misconceptions

A frequent source of confusion is seeing a dropdown on a page and assuming OneNote created it. The control may actually be part of an embedded spreadsheet, a linked web form, or another application displayed alongside the note. If you need to change the available choices, edit the source application rather than looking for a OneNote dropdown setting.

Another issue is using a table as if it validates entries. A table can make a workflow look organized, but OneNote will not automatically reject a misspelling or an unapproved status in a normal cell. If consistent values are important, explain the limitation to users or move that field into Excel or a form.

Finally, do not assume an inserted file is automatically a shared live document. An attachment or spreadsheet object may be stored with the notebook, while a linked workbook may point to a shared file. The distinction affects where edits go and who can see them. Open the link or object from another intended user’s account before depending on it.

Frequently Asked Questions

Can I add a dropdown menu directly to a OneNote page?
No. OneNote does not include a native dropdown field for ordinary page content. You can link to an Excel dropdown or a form, or use a checklist or table when a true selectable control is unnecessary.

Can I make a dropdown in a OneNote table?
No. OneNote tables organize text into rows and columns, but their cells do not support Excel-style data validation. Use an Excel workbook if users must choose from a defined set of values.

Can I embed an Excel dropdown in OneNote?
You can insert or associate Excel spreadsheet content with a OneNote page in supported desktop versions, but the dropdown remains an Excel feature. Check how that spreadsheet object is edited and saved in your OneNote version before sharing it.

Can OneNote check off options like a dropdown?
OneNote checkboxes and to-do tags can mark tasks complete. They are useful for progress tracking, but they do not provide a single-choice menu or enforce a fixed set of answers.

What is the easiest way to share a dropdown with coworkers?
Create the dropdown in an Excel workbook stored in a location the coworkers can access, then add its link to the relevant OneNote page. Test the permissions and edit behavior with a coworker account before relying on it.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.