How to draw a table - Add, edit, and delete column rows in a table in Excel 2016

The following article will guide you in detail How to draw a table - Add, edit, and delete column rows in Excel 2016 tables

1. How to draw a table, create a table in Excel 2016

Select the data area to create a table -> go to the Insert tab -> Tables -> Table:

How to draw a table - Add, edit, and delete column rows in a table in Excel 2016 Picture 1

The Creat Table dialog box appears and click OK:

How to draw a table - Add, edit, and delete column rows in a table in Excel 2016 Picture 2

As a result, you have created a data table with the selected data range. By default, when your data area has no title, you need to enter the column header content again:

How to draw a table - Add, edit, and delete column rows in a table in Excel 2016 Picture 3

If the selected data area contains a title, check the My table has header section to get the first row as the title:

How to draw a table - Add, edit, and delete column rows in a table in Excel 2016 Picture 4

Result of creating table with available title:

How to draw a table - Add, edit, and delete column rows in a table in Excel 2016 Picture 5

After creating the table you need to edit the table style -> click the Design tab -> Quick Styles -> choose the templates and styles for your table:

How to draw a table - Add, edit, and delete column rows in a table in Excel 2016 Picture 6

In addition, you can choose to add other features to the data table in the Design tab -> Tables Style Options :

- Header Row: Allow to hide or show the title of the table

- Total Row: Lets hide the total row at the bottom of the table.

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

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

How to draw a table - Add, edit, and delete column rows in a table in Excel 2016 Picture 7

2. Insert more rows and columns in the table in Word 2016

The simplest and quickest way to create the last row of a table is to place your cursor in the last cell of the table:

How to draw a table - Add, edit, and delete column rows in a table in Excel 2016 Picture 8

Then press the Tab key for the last row created:

How to draw a table - Add, edit, and delete column rows in a table in Excel 2016 Picture 9

In case you want to insert a row at any position that is not the last position of the table -> place the cursor in the row adjacent to the row you want to create more -> right-click and select Tables Row above:

How to draw a table - Add, edit, and delete column rows in a table in Excel 2016 Picture 10

Alternatively you can go to Design -> Insert tab with the following options:

- Insert Cells: Insert more cells

- Insert Sheets Rows: Insert more rows

- Insert Sheets Columns: Insert additional columns

- Insert Table Rows Above: Insert rows above cells containing mouse cursor.

- Insert Table Column to the left: Insert a column to the left of the cursor position.

How to draw a table - Add, edit, and delete column rows in a table in Excel 2016 Picture 11

For inserting columns, you do the same thing.

3. Delete rows and columns in a table in Word 2016

To delete rows and columns, follow these steps:

Step 1: Select the rows or columns to delete -> go to the Design tab -> Delete including the following options:

- Delete Cells: Delete cells

- Delete Sheets Rows: Delete rows

- Delete Sheets Columns: Delete columns

- Delete Table Rows: Delete the table row

- Delete Table Column t: Delete the column of the table

How to draw a table - Add, edit, and delete column rows in a table in Excel 2016 Picture 12

It is up to you whether you want to delete the row or delete the column to select the features accordingly.

In addition, you set up some other features in the Format tab :

How to draw a table - Add, edit, and delete column rows in a table in Excel 2016 Picture 13

The above is a detailed guide How to draw a table - Add, edit, delete column rows in Excel 2016 tables. Wish you success!

4.3 ★ | 3 Vote

May be interested

  • Instructions on 2 simple ways to delete conditional rows in ExcelInstructions on 2 simple ways to delete conditional rows in Excel
    if you want to delete conditional rows in excel, you will have to spend a lot of time selecting and deleting in the data table. that's why this article will show you 2 ways to delete conditional rows in excel very quickly.
  • How to delete, add columns in ExcelHow to delete, add columns in Excel
    adding columns in excel or deleting columns is a basic operation and very simple in excel when we process excel tables.
  • How to draw a table in ExcelHow to draw a table in Excel
    how to draw a table in excel. excel spreadsheets are great tools for calculating numbers. in this article, you can help excel table guys as quickly as possible.
  • How to keep Excel and Excel columns fixed?How to keep Excel and Excel columns fixed?
    fixed excel box, fixed row, fixed excel column when scrolling mouse makes it easy to track and manipulate data sheet. in addition, you can split the excel view area to edit on individual excel areas.
  • MS Excel - Lesson 4: Working with lines, columns, sheetsMS Excel - Lesson 4: Working with lines, columns, sheets
    in addition to the content of tables in excel, operations with lines, columns and sheets in this program are also important. in this article, tipsmake.com will guide you to simple operation to add or remove lines, columns or sheets in excel tables.
  • Manipulating tables editing in ExcelManipulating 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.
  • Instructions for separating column content in ExcelInstructions for separating column content in Excel
    to separate content in an excel field into different columns, we can use two different ways.
  • How to handle cells, columns, rows in a spreadsheet in ExcelHow to handle cells, columns, rows in a spreadsheet in Excel
    the following article will guide you in detail how to handle cells, columns, rows in spreadsheets in excel. 1. change the width of columns, rows and cells in excel. 1.1 resize a row or a column: - hold down the left mouse button for the vertical part of the column and drag the cycle
  • Excel - Convert columns to rows in ExcelExcel - Convert columns to rows in Excel
    if you have an excel file and enter data in the wrong row or column or vice versa, what will you do? would you delete it and re-enter it? that takes up a lot of your time. let's see how taimienphi.vn guides you on how to convert columns into rows in excel.
  • How to Add a Column in a Pivot TableHow to Add a Column in a Pivot Table
    this wikihow teaches you how to create and insert a new column to a pivot table in microsoft excel with the pivot table tools. you can change an existing row, field or value to a column, or create a new calculated field column with a...