Select a cell — I selected B2. Click the Data tab. In the Data Tools group, click Data Validation, and then click Data Validation from the dropdown. From the Allow dropdown, choose List.

When exporting data to Excel, Access creates a copy of the selected data and then stores the copied data in a file that can be open in Microsoft Excel.

In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while scrolling.