If you no longer want a drop-down list in your worksheet, you can remove it.
You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.
You can help people work more efficiently in worksheets by using drop-down lists in cells. Drop-downs allow people to pick an item from a list that you create.
You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)
reference
- cell $A$1 in Sheet1, which is the first item of your drop-down list;rows
& cols
are 0 because you don't want to shift the returned range either vertically or horizontally;height
- the number of non-empty cells in column A, returned by the COUNTA function;width
- 1, i.e. one column.='Source Book.xlsx'!Source_list