Excel typically looks for templates in the Custom Office Templates folder. To find this folder, go to File > Options > Save and check the path under Default personal templates location . 2.

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.