How to create an Excel table. 1. ... Type the name of the new column in row 3 and notice that Excel adds the filtering and style format automatically. 11. It’s also easy to add new records.