How to create an Excel table 1. First, enter the field names in the columns across the top, and then enter some records/data in the rows under each column.

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques.