Manipulating tables in Excel

The following article provides detailed instructions for you to create tables in Excel.

Manipulating tables in Excel Picture 1

To create the table, follow these steps:

Step 1: Go to the Insert tab -> Tables -> Table:

Manipulating tables in Excel Picture 2

Step 2: The Create Table dialog box appears -> in the Where is the data for your table section, select the data area to create the table -> OK:

Manipulating tables in Excel Picture 3

Step 3: After selecting OK, the data table has been created as shown below:

Manipulating tables in Excel Picture 4

Step 4: In case you want to change the display style of the table, do as follows: Click on the table -> go to the Design tab -> select the display type of the table in Quick Style:

Manipulating tables in Excel Picture 5

Step 5: Or you can select the contents shown on the table by clicking the Table Style Options item in it:

- Section Header Row: Hide / show the title of the table.

- Section Total Row: Hide / show the total row at the bottom of the table.

- First Column: Display special format for the first column of the table.

- Last Column: Display special format for the last column of the table.

Manipulating tables in Excel Picture 6

Above is a detailed guide for creating tables in Excel 2013.

Good luck!