Manipulating Tables in Excel

This guide provides a practical overview of Manipulating Tables, including its main features, benefits, limitations, and important considerations.

To create the table, follow these steps:

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

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:

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

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:

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.

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

Good luck!