Create a table

You can create a table only on the current sheet of the document if the sheet is not protected from changes and in Edit mode only.

When you select a cell range for a table, it is recommended that you consider the following constraints:

•The selected range cannot overlap with another table or pivot table.

•There should be at least one empty row between the selected range and the closest table, pivot table, merged cell, or other range containing filters.

•The selected range should not contain any cells with filters, unless they are cells in the first row of the range.

•If the first row of a range has filters, that range should not intersect or be part of another range with filters.

To create a table, follow these steps:

1.Select one of the following elements required to create a table:

•The range of cells that will be used to create a table.

•A single cell within the data range, or an empty cell adjacent to the range if you want to use the entire range.

2.Open the Create table dialog box in one of the following ways:

•On the Insert tab, click  Table.

•When working in macOS, select the Insert > Table command from the command menu.

•Press Ctrl+T (Windows, Linux) or  Cmd+T (macOS).

3.If necessary, edit the range in the Value source field. To do this, enter the address in the field directly or, by clicking  Select values, select the desired cells in the document. If you make an error when entering, follow the on-screen prompts.

4.If necessary, edit the table name in the Name field. The table name should be unique to the document, contain no spaces, and begin only with the letter or characters “_” or “\”.

5.Clear the Include headers in the table checkbox if you do not want the cells in the first row of the selected range to be converted to table headers. If you clear the checkbox, a new row will be created with automatically generated header names.

6.Click OK.