Quick answer
A dropdown only shows items included in its validation source. Find out whether that source is a typed list, a fixed cell range, a named range or a table before adding a choice.
Understand the problem before changing anything
Adding a new department below an existing list does not extend a fixed reference such as =$A$2:$A$5. A named range can have the same limitation. Check the validation cell, not just the visible list of labels.
Step-by-step checks
Open the dropdown’s rule
Select an affected cell and choose Data > Data Validation. Read the Source field and note whether it contains text, a range or a name.
Edit the actual source
For typed choices, add the new item using the separator expected by your Excel setup. For a range, place the new value in the source cells.
Extend a fixed reference
Ensure the reference includes the newly added row. If a named range is used, inspect its definition in desktop Excel where necessary.
Check other input cells
A workbook may contain several copies of a validation rule. Apply the intended update consistently without changing unrelated lists.
Test the finished dropdown
Select the new choice and an existing choice. Check any dependent formulas, lookup tables or reports that use those values.
What to avoid
Do not include the source heading as a choice or introduce accidental blank entries. Some dropdown-editing features differ between Excel for the web and desktop Excel.
How to verify the result
The new value should appear in every intended input cell. Its spelling should match any lookup table that controls pricing, reporting or dependent lists.
Check the workbook’s structure as well as the visible result
Work on a separate copy when the workbook supports invoices, stock, payroll or a shared report. A cell’s appearance is only one layer: its stored value, formula, number format and validation rule can differ. Record the affected worksheet and one example cell so you can compare the same case after each change.
Use a small, known example to test the intended behaviour. Check one ordinary row, one blank and one unusual value rather than judging a whole report from its grand total. If the workbook imports data, correct the import or source definition where possible; repeatedly correcting the final display can leave the same problem waiting for the next refresh.
Before sharing the result, check formulas that depend on the changed area and any charts or PivotTables fed by it. Save, close and reopen a working copy, then verify the same example. Mention any deliberate conversion of text, dates or identifiers so another user does not reverse it accidentally. If a colleague owns the workbook, agree changes to validation, protection and calculation settings rather than silently changing the model.
Before you finish
- Affected sheet and sample cell
- Original value compared with expected value
- Source, formula and display checked separately
- Dependent reports tested after saving
Common question
Why is the new value visible on the sheet but absent from the dropdown?
It may sit outside the validation source. Inspect the exact cell range or named range used by that dropdown.
Need help with the next step?
Tell RJ Computers the device model, exact symptom, checks already tried and whether important files are backed up. Confirm availability, assessment charges and the scope of work before arranging a visit.
Reference and version notes
Check the official instructions for your exact product version; menu names and available features can differ.
Official product documentation