Manipulating tables in Excel

Guide you to create tables in Excel. To create the table you perform the following steps: Step 1: Go to the Insert - Tables - Table tab: 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 .

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

Picture 1 of Manipulating tables in Excel

To create the table, follow these steps:

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

Picture 2 of Manipulating tables in Excel

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:

Picture 3 of Manipulating tables in Excel

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

Picture 4 of Manipulating tables in Excel

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:

Picture 5 of Manipulating tables in Excel

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.

Picture 6 of Manipulating tables in Excel

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

Good luck!

Update 19 May 2020
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile