excel spreadsheet with drop down menus

Question

How do i create an excel spreadsheet with drop down menus for cases I reviewed for carf

Answer 1

Hello,

You will want to use the data validation feature. The instruction is here https://support.microsoft.com/en-us/office/create-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce407b

Answer 2

To track reviewed cases with drop-down menus in Excel for Windows, use Data Validation lists in the cells where the choices are needed (for example: Status, Outcome, Reviewer, CARF area, etc.).

Basic steps to create a drop-down list (Windows):

1. Prepare the list of choices
   1. In a new worksheet (or an unused area of the current sheet), type the items you want in the drop-down list in a single column, one item per cell (for example: Open, In Review, Complete, Deferred).
   2. Optionally, convert this list to an Excel table so it can auto-expand later:
      • Select any cell in the list and press Ctrl+T.
2. Select where the drop-down will appear
   1. Go to the sheet where the CARF cases are tracked.
   2. Select the cell (or range of cells) where the drop-down should be used (for example, the entire “Status” column).
3. Add Data Validation – List
   1. On the Ribbon, select the Data tab.
   2. Select Data Validation.
   3. In the Settings tab, in the Allow box, select List.
   4. In the Source box:
      • Either select the range that contains the list items (for example, a table column on another sheet), or
      • Type the items directly, separated by commas, for example: Open,In Review,Complete,Deferred.
   5. Make sure In-cell dropdown is checked so the arrow appears.
   6. If blanks are allowed, leave Ignore blank checked.
   7. Select OK.
4. (Optional) Add an input message or error alert
   1. In Data > Data Validation, use the Input Message tab to show a short note when the cell is selected (for example, “Select the case status from the list”).
   2. Use the Error Alert tab to show a message if someone types a value that is not in the list.
5. Test the drop-down
   1. Click a cell with validation and confirm the drop-down arrow appears.
   2. Select different options and verify they match how CARF cases should be categorized.

Repeat these steps for any other fields that should use drop-downs (such as program type, reviewer name, or compliance result). If the source lists are in tables, adding or removing items from those tables will automatically update all related drop-downs.

---

References:

• Create a drop-down list
• Apply data validation to cells