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.

However, if the column data is numeric, the headings are probably the widest text in the column. Making these headings vertical conserves space and allows you to view more columns without scrolling.