Automatically add table field header features with Excel 2007

Excel 2007 has the ability to automatically add table field headers. When we enter table data in Excel2007, if you apply a table style to the table, as long as you enter data in a blank cell to the right of the table, Excel2007 automatically adds a new field heading and automatically identifies and applies the appropriate name and format. You just need to focus on the input of the next important data without having to spend any effort on the formatting and appearance of the table.

Diagram: Automatically add field headers

Let's take a look at how to use Excel 2007 to automatically add table field headers to this feature.

Make a simple table (pictured) at your disposal first.

Diagram: Making a table

box to select the table data.

Diagram: Box selection table