Excel Table Properties: What They Are and How to Use Them

How-to basics · Updated November 18, 2026

Excel table properties are the settings that control a table’s name, size, headers, filters, style, and summary row. In Microsoft Excel for Microsoft 365 on Windows, select a cell in the table to open the contextual Table Design tab, where you can view or change most of these settings.

What Excel means by table properties

An Excel table is a structured data range, not merely a group of cells with borders or a color scheme. Turning a range into a table adds features for organizing and working with records: filter buttons in the headers, automatic expansion when data is added, table-specific formatting, and structured references in formulas. Its properties are the controls that define how those features behave.

There is not one universal Properties dialog for every Excel table. The standard table’s main controls appear on the ribbon when you select it. Some settings, such as the table’s name or whether it shows a Total Row, are easy to change there; other details, such as column widths, are ordinary worksheet formatting rather than table properties.

This distinction matters when troubleshooting. A range can look like a table because it has colored rows and bold headings, yet lack table features. To check, select a cell: if Table Design appears on the ribbon, it is an Excel table. If it does not, the selection may be a normal range or a formatted range.

How to create and name a table

Select a cell in a contiguous range of data, then choose Insert > Table. You can also select Home > Format as Table and choose a style. In the dialog, confirm the range and select My table has headers if the first row contains field names. On Windows, Ctrl+T opens the Create Table dialog for a selected data range. In Excel for Mac, use Insert > Table; keyboard shortcuts can differ according to the keyboard and Excel version.

Excel assigns a default name, such as Table1. To give it a useful name, select a table cell, open Table Design, and edit the Table Name box at the left of the ribbon. Names must be unique within the workbook and cannot contain spaces. For example, a table of orders might be called Orders2026 rather than Table3. Descriptive names make formulas and references easier to understand.

Before creating a table, check that each column has a clear heading and that the data is arranged in a simple rectangle. Avoid blank rows or columns inside the data, merged cells in the header, and multiple header rows. Excel expects one header row and one record per row. When duplicate or missing headings are encountered, Excel may adjust or supply headings, so review them after conversion.

Main settings on the Table Design tab

The Table Design tab combines table-level controls with visual options. The available controls can vary slightly with the window size and Excel build, but these are the settings most people mean by table properties:

  • Table Name: Identifies the table in formulas, the Name Manager, and other workbook features. Changing the name does not change the worksheet data.
  • Resize Table: Changes the range included in the table. You can add or remove rows and columns by editing the range in the dialog, or drag the resize handle at the table’s lower-right corner.
  • Header Row: Shows or hides the table’s displayed header row. A table still needs field names for its columns, even if the header display is turned off.
  • Total Row: Adds a summary row at the bottom. A cell in this row can offer calculations such as Sum, Average, Count, or Maximum. The exact choices depend on the column’s contents.
  • Banded Rows: Applies alternating row emphasis to help readers track records across wide tables. Banded Columns can apply a similar treatment vertically.
  • First Column and Last Column: Emphasize those columns using the selected table style. These options affect appearance, not the underlying data or calculation.
  • Filter Button: Shows or hides the header drop-down arrows used to sort and filter. Hiding the buttons does not delete records or turn the table into a range.
  • Table Styles: Applies a built-in or custom visual style. Style Options determine which parts of that style are emphasized.

For example, a product table could use a bold first column for item names, banded rows for readability, and a Total Row for inventory value. Those choices change presentation and convenience; they do not replace good data organization or validate the values entered.

Sorting, filtering, and table expansion

Each header’s filter button provides sorting and filtering choices for that column. Filtering hides records that do not meet the selected criteria; it does not remove them. Clear a filter to show the full list again. Filters can be combined, so a sales table can show one region and a date range at the same time. Sorting rearranges the displayed records in the table, so use care if nearby worksheet data is not part of the same table.

Tables usually expand when you type in the row immediately below them or enter data in the adjacent column. Pressing Tab from the last cell in the final data row can create a new table row. Expansion is useful because table formatting, formulas in calculated columns, and structured references can extend with the data. If the table does not include a new block of pasted data, use Table Design > Resize Table to set its range explicitly.

Table boundaries matter. A chart, note, or second data set directly beside a table can make it less obvious where one structure ends and another begins. Keep unrelated information separate, and verify the range in Resize Table if sorting or filtering appears to affect an unexpected set of cells.

Structured references and calculated columns

Tables support structured references, which use table and column names instead of ordinary cell coordinates. These references are easier to read and generally adjust when rows or columns are added to the table. For example, a formula can refer to every value in the Amount column as Sales[Amount], where Sales is the table name. A reference such as [@Amount] means the Amount value in the current table row.

Suppose a table named Sales has Quantity and Unit Price columns, and a row contains 3 and 8. The formula below, entered in a new Amount column in that row, multiplies those two values and returns 24. As Excel recognizes the entry as a calculated-column formula, it can fill the same formula through the rest of the column.

With a table named Sales and columns Quantity, Unit Price, and Amount, enter this formula in the Amount column of the row containing Quantity 3 and Unit Price 8: =[@Quantity]*[@[Unit Price]]. It returns 24.

Structured references can also summarize a column. If Sales has three Amount values—24, 15, and 8—the following formula returns 47. The example assumes the formula is entered in a worksheet cell outside the Sales table.

With the table named Sales and its Amount column containing 24, 15, and 8, enter: =SUM(Sales[Amount]). The result is 47.

These examples use standard Excel table-reference syntax, not a separate table-only function. If you rename a table or column, Excel normally updates its structured references. However, formulas copied as plain text or references built outside Excel may need checking after a rename.

Formatting and data quality

A table style is a quick way to apply consistent header, row, and column formatting. To change it, select a table cell, open Table Design, and choose a different style from the Table Styles gallery. If the gallery is collapsed, expand it to see more options. The Header Row, Total Row, and banding options can be adjusted independently of the selected style.

Formatting does not determine what a value means. A date-looking entry may be stored as text, and a number with currency formatting is not automatically a verified monetary amount. Tables also do not enforce a complete data-validation policy by default. For reliable analysis, use consistent column types and headings, check imported values, and apply data validation where appropriate.

Tables can help make data easier to scan, but visual emphasis should remain readable. Avoid choosing a style solely because it is colorful, particularly when a workbook may be printed or viewed by people with color-vision differences. The actual values and clear headings should still carry the meaning.

Changing, converting, or removing a table

To add or remove cells from a table without converting it, use Table Design > Resize Table and specify the new range. To remove duplicate records, the Table Design tab also provides Remove Duplicates. Review the selected columns in that dialog: removing duplicates based on only one field can remove rows that differ in other fields.

To keep the data but remove table behavior, select a table cell and choose Table Design > Convert to Range, then confirm. The cells remain on the worksheet, and the existing formatting is generally retained, but table-specific features such as automatic expansion and structured references no longer work as table features. Formulas that refer to the former table may be converted or changed, so inspect important formulas afterward.

To remove the contents as well, select the table’s cells and use the worksheet’s delete or clear commands; converting to a range alone does not delete data. In Excel for Mac, the contextual tab is also available after selecting the table, though the ribbon layout can differ. If a command is not visible, check the Table Design tab or its overflow area rather than assuming the feature is absent.

Common problems and misconceptions

  • The Table Design tab is missing: Click inside the table. The contextual tab appears only when a table cell is selected. If it still does not appear, check whether the range is actually a table.
  • New rows are not included: The entered data may not be adjacent to the table, or automatic expansion may not have occurred. Use Resize Table and confirm the range includes the new records.
  • A formula shows a name error: Check the table name and column heading for spelling differences. Structured references use the actual names, including spaces and punctuation in headings.
  • Sorting moved unrelated cells: Data outside the table is not necessarily part of its records. Keep associated fields inside the same table and confirm the selection before sorting.
  • The Total Row seems to ignore filtered-out entries: Its built-in summary choices commonly use SUBTOTAL behavior, which can calculate visible records rather than every record. Check the chosen calculation and whether a filter is active.

A common misconception is that applying a table style creates a table. A style can be applied to an ordinary range, while a real Excel table has a table name and table-specific behavior. Another is that hiding filter buttons turns off filtering; it hides the controls but does not itself convert or clear the table.

Standard tables versus external data properties

Most people asking about Excel table properties mean the settings on Table Design for a normal worksheet table. A table or range populated from an external data connection can have additional refresh and connection settings. Those settings relate to where data comes from and how it is updated, not to the standard table style or header options. The exact controls depend on how the data was imported and the connection type.

If you need to change refresh behavior, look for the query or connection associated with the imported data rather than changing the table’s banding or name. Conversely, renaming a standard table does not change the source database or connection. Keeping these two meanings of properties separate helps avoid changing the wrong setting.

Frequently Asked Questions

Where do I find Excel table properties?
Select any cell in the table and open the Table Design tab. The Table Name, Resize Table, style, header, filter-button, and Total Row controls are among the settings available there.

How do I change an Excel table name?
Select a cell in the table, go to Table Design, and replace the text in the Table Name box. Use a unique name without spaces, then press Enter to apply it.

Can I change a table back to a normal range?
Yes. Select a table cell and choose Table Design > Convert to Range, then confirm. The cells remain, but table-specific behavior is removed.

Do Excel table properties include column width?
No. Column width is worksheet formatting rather than a table-level property. You can still adjust a table column’s width using the worksheet column headings or the Home tab’s formatting controls.

Does hiding the Header Row delete the table headings?
No. The Header Row option changes whether the header row is displayed as part of the table view. The table still relies on column names for its structure and references.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.