Select a cell within your data. Select Home and choose Format as Table under Styles. Choose a style for your table. In the Create Table dialog box, confirm or set your cell range. Mark if your table has headers, and select OK.

You’ll be able to add your data in a table from the Insert tab. Follow these steps to get your data into a table! Select a cell inside your data. Go to the Insert tab. Select the Table command in the Tables section. This is going to open the Create Table menu with your data range selected.

You can create as many tables as you want in a spreadsheet. To quickly create a table in Excel, do the following: Select the cell or the range in the data. Select Home > Format as Table. Pick a table style.

To create a table, execute the following steps. 1. Click any single cell inside the data set. 2. On the Insert tab, in the Tables group, click Table (or simply press Ctrl + T). The Create Table dialog box appears. 3. Excel automatically selects the data for you.