How to create a bulleted list using a function in Excel Follow the steps below on how to create a bulleted list using a function in Excel: Launch Microsoft Excel. Enter data or use existing data.

Then, use the named range as the source reference for the dropdown. As long as the Scope setting is the entire workbook, everything will update as expected, even though the list is on another sheet.