Skip to main content

Create smart table

You can create smart tables. The new table must not overlap with other smart tables or pivot tables. Ensure there is at least one blank row between your data range and other tables or filtered ranges.

Insert a smart table​

  1. Select a cell or range of cells containing your data.
  2. On the Insert tab, click the Table button.
  3. In the dialog box, change the Value source and table Name if necessary.
  4. If your first row contains column headings, enable the Include headers in the table option.
  5. Click OK.

You can also use the keyboard shortcut Ctrl+Alt+T (Cmd+Option+T).