1
00:00:00,080 --> 00:00:03,817
You add Waiting beneath an Excel status list, but the dropdown

2
00:00:03,817 --> 00:00:06,535
still offers only Queued, In progress, and Done.

3
00:00:06,535 --> 00:00:10,272
A dropdown backed by a fixed cell range does not include

4
00:00:10,272 --> 00:00:11,970
a cell outside that range.

5
00:00:11,970 --> 00:00:15,707
We will inspect the validation source, expand the source range in

6
00:00:15,707 --> 00:00:20,463
Excel for the web, and test the exact new choice in a fictional tracker.

7
00:00:21,063 --> 00:00:25,058
Paste the fictional CSV into a new workbook: statuses occupy A

8
00:00:25,058 --> 00:00:26,511
two through A four.

9
00:00:26,511 --> 00:00:30,505
In D two, create a dropdown from A two through A

10
00:00:30,505 --> 00:00:31,958
four using Data validation.

11
00:00:31,958 --> 00:00:33,410
Test the three choices.

12
00:00:33,410 --> 00:00:37,405
Then type Waiting in A five, outside the original source range.

13
00:00:37,405 --> 00:00:41,763
The CSV supplies text, not a ready-made validation rule; D two

14
00:00:41,763 --> 00:00:44,668
is the separate entry cell for this exercise.

15
00:00:45,268 --> 00:00:48,370
Select D two and open its Data validation settings.

16
00:00:48,370 --> 00:00:52,506
Read the Source box instead of guessing which list powers the dropdown.

17
00:00:52,506 --> 00:00:56,297
In this exercise it refers to A two through A four,

18
00:00:56,297 --> 00:00:59,399
so Waiting in A five remains outside the source.

19
00:00:59,399 --> 00:01:03,191
If your own Source box has typed entries or a named

20
00:01:03,191 --> 00:01:08,361
range, follow that source type's editing method; a named range may need desktop Excel.

21
00:01:08,961 --> 00:01:13,299
For this direct cell-range source, reopen Data validation for D two.

22
00:01:13,299 --> 00:01:17,636
In Excel for the web, Microsoft's instructions say to clear the

23
00:01:17,636 --> 00:01:21,613
old Source entry, then select the cells A two through A

24
00:01:21,613 --> 00:01:24,866
five again so Waiting is included. Confirm the change.

25
00:01:24,866 --> 00:01:28,843
If this control is unavailable in your web session, use desktop

26
00:01:28,843 --> 00:01:31,735
Excel rather than claiming an unobserved web result.

27
00:01:32,335 --> 00:01:35,339
Return to D two and open the dropdown.

28
00:01:35,339 --> 00:01:39,469
Verify that Queued, In progress, Done, and Waiting each appear once.

29
00:01:39,469 --> 00:01:43,224
Select Waiting and confirm D two displays exactly that text.

30
00:01:43,224 --> 00:01:47,354
This is stronger than checking the source range alone: it proves

31
00:01:47,354 --> 00:01:51,485
the validation rule now points to the intended cells and the

32
00:01:51,485 --> 00:01:54,113
list works for the person entering data.

33
00:01:54,713 --> 00:01:59,125
Excel lists can also be built from manually entered values or named ranges.

34
00:01:59,125 --> 00:02:01,500
Those are not the same editing path.

35
00:02:01,500 --> 00:02:05,572
In Excel for the web, Microsoft's current guidance supports changing a

36
00:02:05,572 --> 00:02:08,626
typed list or reselecting a direct cell-range source.

37
00:02:08,626 --> 00:02:13,377
For a named-range source, the help page directs you to the desktop version.

38
00:02:13,377 --> 00:02:18,467
Identify the source type first so you do not promise an unavailable web-only fix.

39
00:02:19,067 --> 00:02:22,993
The exercise succeeds when the four expected statuses are visible and

40
00:02:22,993 --> 00:02:25,849
Waiting can be selected in the entry cell.

41
00:02:25,849 --> 00:02:29,775
The downloadable CSV only provides the fictional text; it is not

42
00:02:29,775 --> 00:02:31,560
a ready-made validation workbook.

43
00:02:31,560 --> 00:02:35,486
If your own dropdown still omits an item, check the exact

44
00:02:35,486 --> 00:02:39,769
range and whether a blank row or hidden space separated the list.

45
00:02:39,769 --> 00:02:42,982
Keep the tracker copy until the new status works.