Create Tables

You can create a table from a data range that is set up with a header row. If your range does not include a header row, you should add one.Follow these steps to create a table from a range:

1. Select any cell in the range.
2. Click the Insert tab on the Ribbon and then click the Table button (or press Ctrl+L). Excel displays the Create Table dialog box and selects the entire contiguous range that includes the active cell pointer.
   
   
3. Click OK. Excel creates the table, applies a default style, and adds a sort and filter arrow to the cells in the header row. Excel also displays the Table Tools Design tab on the Ribbon.

Manually adding records into a table

To manually create a list by using the Table command, follow these steps:

1. Identify the fields in your list.
   To identify the fields in your list, enter the field names into row 1 in a blank Excel workbook. For example, Figure shown below a workbook fragment. Cells A1, B1, C1, and D1 hold field names for a simple list.
   
   
2. Select the Excel table.
   The Excel table must include the row of the field names and at least one other row. This row might be blank or it might contain data. you can select an Excel list by dragging the mouse from cell A1 to cell D2.
3. Choose Insert> Table to tell Excel that you want to get all official right from the start.
   If Excel can't figure out which row holds your field names, Excel displays the dialog. This dialog box just lets you confirm that the first row in your range selection holds the field names. To accept Excel's guess about your table, click OK. Excel redisplays the worksheet set up as a table, as shown in Figure below.
   
   
4. Describe each record.
5. Store your record in the table.
   Click the Tab or Enter button when you finish describing some record. Excel adds another row to the table so that you can add another item. Excel shows you which rows and columns are part of the table by using color.