-
Select the cells where you want to insert the table.
-
On the Insert tab, select
Table or press CTRL+T. This shows you the selected range. -
Check My table has headers if your table has headers, and then select OK.
When you check My table has headers, Excel uses the first row as the headers, if not, it adds Column1, Column2, etc on the first line and moves the table down one row.
Tip: To change color style, select a cell in the table, and on the Home tab, choose Format as table to see a gallery of options.
-
Select the cells where you want to insert the table.
-
Go to Insert and select
Table or press ⌘+T. This shows you the selected range. -
Check My table has headers if your table has headers, and then select OK.
When you check My table has headers, Excel uses the first row as the headers, if not, it adds Column1, Column2, etc on the first line and moves the table down one row.
Tip: To change color style, select a cell in the table, and on the Home tab, choose Format as table to see a gallery of options.
-
Select the cells where you want to insert the table.
-
Go to Insert and select
Table or press CTRL+L. This shows you the selected range. -
Check My table has headers if your table has headers, and then select OK.
When you check My table has headers, Excel uses the first row as the headers, if not, it adds Column1, Column2, etc on the first line and moves the table down one row. -
Tip: To change color style, select a cell in the table, and on the Home tab, choose Format as table to see a gallery of options.