How to make a convenient list

Click here for explanation 🔻

[How to make a super convenient list!

① Enter the candidate you want to pull down in another cell

② Select the cell you want to set the pull-down

③ Open the data tab

④ Click "Data Entry Rules"

Select "List" as the type of input value

⑥ Specify the candidate cell range as the original value and OK

If you specify a table column as "Original value," it will be automatically reflected in the pull-down when adding candidates 🤩

# excel

# Excel

# excel _ beginner

The office job