After you create an Excel table in your worksheet, you can easily add or remove table rows and columns. You can use the Resize command in Excel to add rows and columns to a table: Click anywhere in the table, and the Table Design tab appears. Select Table Design > Resize Table.
Excel provides numerous predefined table styles that you can use to quickly format a table. If the predefined table styles don't meet your needs, you can create and apply a custom table style.
Learn about the many ways to create a table in an Excel worksheet, and how to clear data, formatting, or table functionality from a table in Excel. Discover more in this video.
After you create an Excel table, you may only want the table style without the table functionality. To stop working with your data in a table without losing any table style formatting that you applied, you can convert the table to a regular range of data on the worksheet.
After you create a PivotTable, you can change the range of its source data. For example, you can expand the source data to include more rows of data. However, if the source data has been changed substantially—such as having more or fewer columns, consider creating a new PivotTable.
Use the Name Manager dialog box to work with all the defined names and table names in a workbook. For example, you may want to find names with errors, confirm the value and reference of a name, view or edit descriptive comments, or determine the scope.
Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with predefined names for the items in a table.
