Instead of creating and formatting an entire worksheet, you might prefer to use a data table to store your Excel data. Excel 2013 includes a gallery of predesigned table formats that you can use to create the table. You can then work with table information and name and resize the table as needed.
Type your table headers in a single row.
Click any cell in the range from which you want to create a table.
On the Home tab, click Format As Table.
Click the desired table style.
Verify that Excel identified the data range correctly.
If your table has headers, select the My Table Has Headers check box.
Excel applies the data table format to your data.