Home > Sample chapters > Microsoft Office > Excel

Analyzing Your Excel 2013 Data

Creating and modifying data tables

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.

Create an Excel table

  1. Type your table headers in a single row.

  2. Click any cell in the range from which you want to create a table.

  3. On the Home tab, click Format As Table.

  4. Click the desired table style.

  5. Verify that Excel identified the data range correctly.

  6. If your table has headers, select the My Table Has Headers check box.

  7. Click OK.

    Excel applies the data table format to your data.

    httpatomoreillycomsourcemspimages1532039.jpg
    httpatomoreillycomsourcemspimages1532041.jpg

Name an Excel table

  1. Click any cell in the Excel table.

  2. Click the Table Tools Design tab.

  3. In the Properties group, type a new name for your Excel table and press Enter.

Resize an Excel table

  1. Click a table cell.

  2. Click the Table Tools Design tab.

  3. In the Properties group, click Resize Table.

    The Resize Table dialog box opens.

  4. Specify a new cell range for the table.

  5. Click OK.