Applies ToExcel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web
  1. Select the cells where you want to insert the table.

  2. On the Insert tab, select  Table button Table or press CTRL+T. This shows you the selected range.

  3. 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.

  1. Select the cells where you want to insert the table.

  2. Go to Insert and select  Table button Table or press ⌘+T. This shows you the selected range.

  3. 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.

  1. Select the cells where you want to insert the table.

  2. Go to Insert and select  Table button Table or press CTRL+L. This shows you the selected range.

  3. 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. 

  4. 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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.