HomeApplicationOffice informationManipulating tables in Excel

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!

4.5 ★ | 2 Vote

You should read it

May be interested

  • Table operations in ExcelPhoto of Table operations in Excel
    instructions on table operations in excel. when working with tables you should pay attention to the following: 1. edit the width of rows and columns. there are many ways to edit the widths of rows and columns. method 1: with the column moving into the vertical bar of the column - when the child
  • Manipulating tables editing in ExcelPhoto of Manipulating tables editing in Excel
    instructions to manipulate tables in excel. 1. insert rows and columns in the table: - for example, want to insert 1 column after salary column 1 day: step 1: select the column number of days - go to home - cells tab - insert - insert sheet column.
  • Format borders and background colors for tables in ExcelPhoto of Format borders and background colors for tables in Excel
    instructions on how to format borders and background colors for tables in excel. step 1: select the table you want to create a border for - design - quick styles - select the table style: light is the light color format, medium is the medium format.
  • Top 3 software to read PDF files bestPhoto of Top 3 software to read PDF files best
    pdf is the most commonly used file format. with this format will minimize the editing of content. the following article introduces you to the top 3 best pdf file readers today.
  • Round a number in Excel (ROUND function)Photo of Round a number in Excel (ROUND function)
    instructions on how to round numbers in excel, help calculate faster depending on how to round the number of digits after and before the comma, there are many number rounded functions in excel. 1. round a number using the round () function - meaning: rounds to the nearest number
  • How to reduce the size of Excel filesPhoto of How to reduce the size of Excel files
    instructions on how to reduce the size of excel files. in order to reduce the file size, you need to determine the reason why your file size is very large. if you can't find it, you can reduce the file size by doing the following: 1. save the file as a binary file 2. delete

Office information