Convert Data Into an Excel Table Before you convert your Excel data into a table, make sure you have column headers along the top row. This will make dealing with and using the data much more ...

Next, if your table has headers, check this option in the Create Table dialog box. If it doesn't, leave this option unchecked, and Excel will add a header row for you.

Select the columns you want to fix. In this case we’re selecting the header columns — those at the very top of the ...

Use these six shortcuts to select Table elements and insert columns and rows quickly in Microsoft Excel, making your use of Tables that much easier.

When Excel prompts you to confirm the conversion, note the header question, and then, click OK. Figure A shows two table objects in the same Excel sheet.

Excel tables have column-sorting buttons in the header row to the right of the word in each cell. Data rows in Excel tables have contrasting color schemes.