When you wish to “upgrade” your plain table into a proper Excel Data Table, click anywhere in the data and press
Assuming you have no blank rows or columns, and you have a header row, you can press ENTER and you have your newly upgraded table.
You now have access to all the bells, whistles, and toys for manipulating Data Tables, like
- Adding a total row
- Adjusting row/column banding
- Summarizing with a PivotTable
- Inserting Slicers for advanced filtering
If you want all the features of a proper Data Table, but none of the art styling, press the lower of the three buttons to the right of the Table Styles group and select Clear.
This will remove all the artistry from the table while retaining all other Data Table functionality.
If you wish to remove ALL Data Table functionality and return to a plain table, click Convert to Range in the Tools group of controls.