3. In the General group, click the Index Column dropdown, and choose From One (Figure F). Figure F Create an index field beginning with the number 1. 4. Close the query, and save when prompted.

In this tutorial, I’ll show you how to populate a dropdown with data on another sheet. I’m using Microsoft 365 desktop on a Windows 10 64-bit system, but you can use older .xlsx versions.