Excel Table Maker: Create and Format Tables Easily

How-to basics · Updated November 18, 2026

Excel has a built-in table maker: select your data, press Ctrl+T on Windows, confirm whether it has headers, and choose OK. On a Mac, use Insert > Table. The result is a real Excel table, not just a colored range: it includes filter controls and can automatically extend as you add data.

What an Excel table maker does

People searching for an Excel table maker may mean a tool that turns data into a formatted table, or a downloadable template that is already laid out. For most workbooks, no extra maker is needed. Excel can convert an ordinary block of data into a structured table, apply a style, and add useful behaviors such as sorting, filtering, and automatic formula copying.

A table is especially useful when a list will grow or when you need to analyze records consistently. For example, a small sales list might have columns for Date, Product, Quantity, Unit Price, and Amount. Converting that range into a table makes each header a field that can be filtered, while new rows can inherit the table’s formatting and calculated-column formulas.

A table is different from simply using borders, bold text, or the Format as Table gallery. Applying a table style to a selected range through Home > Format as Table also creates an actual table. By contrast, manually coloring cells or adding borders changes appearance only; it does not add table filters or structured references.

How to make a table in Excel

Start with one continuous rectangular range. Put one clear label in the first row of each column, and place one record on each following row. Avoid blank rows or columns inside the data, merged cells, and separate notes within the range. These practices help Excel identify the correct boundaries and keep each record intact when sorting.

  1. Click any cell inside the data. If Excel does not identify the intended range, select the full range first, including the header row.
  2. On Windows, press Ctrl+T, or choose Insert > Table. On Mac, choose Insert > Table; menu and shortcut availability can vary by Excel version.
  3. Check the range shown in the Create Table dialog. Select My table has headers if the first row contains labels such as Date or Product.
  4. Choose OK. Excel creates the table and displays filter arrows in the header cells.
  5. With a table cell selected, open the Table Design tab to choose a style, change the table name, or turn table options on and off.

If the selected range has no headers, leave My table has headers unchecked. Excel supplies generic column labels, which you can replace with meaningful names. Headers should be distinct and nonblank; if labels are duplicated or missing, Excel may adjust them to make the table usable. Review the resulting names before building formulas or reports around them.

How Excel tables work

Tables expand more reliably than ordinary formatted ranges. Typing directly in the row below a table or pasting data immediately beside it will generally extend the table, provided there is no empty separating row or column. New rows can inherit the table style and formulas in calculated columns. If an addition does not join the table, use the resize command on the Table Design tab or drag the table’s resize handle, where available.

Each table also has a name, such as Table1. You can give it a descriptive name in the Table Name box on Table Design, for example Sales. Names make formulas easier to understand and can be used in other workbook features. A table name must be unique in the workbook and cannot contain spaces; use an underscore or a joined name instead.

Tables use structured references to identify columns by their headers rather than by cell addresses. That can make a formula easier to read and more resilient when a table grows. For instance, a formula that refers to Sales[Amount] means the Amount column of the table named Sales, not a fixed range that stops at a particular row.

Formatting and useful table options

When you select a table cell, the Table Design tab presents style and behavior options. The Table Styles gallery applies coordinated header, banded-row, and emphasis formatting. Banded rows can make wide lists easier to follow across the screen, but a style is presentation rather than a change to the underlying values.

Useful options on Table Design include Header Row, Total Row, Banded Rows, First Column, Last Column, and Filter Button. The exact layout can vary slightly by platform and window size. Turning off Filter Button removes the header drop-down arrows; it does not convert the table back to a normal range.

The Total Row option adds a summary row at the bottom. Its cells can use summary calculations such as Sum, Average, Count, or Max, selected from the total-row drop-down. Excel commonly uses the SUBTOTAL function for these summaries so that filtered-out records are not included in the visible total. This is useful for a filtered sales list, where the displayed total should reflect only the records currently shown.

Using formulas in a table

Tables simplify formulas that repeat down a column. Suppose a table named Sales has columns Quantity and Unit Price, and you add a column named Amount. In the first data row of Amount, enter the following formula. Excel will typically fill it down the calculated column and apply it to new table rows as well.

With the current row’s Quantity and Unit Price columns in the Sales table, enter =[@Quantity]*[@[Unit Price]] in the Amount column. If that row has Quantity 3 and Unit Price 12, the result is 36. The @ symbol indicates the value from the current row; the brackets let Excel refer to column headings, including a heading that contains a space.

For a total that responds to filters, suppose Sales[Amount] contains three values: 36, 42, and 60. In a cell outside the table, enter =SUBTOTAL(109,Sales[Amount]). With all three records visible, the result is 138. The function number 109 requests a sum that also ignores manually hidden rows; filtered-out rows are excluded. If the table is renamed, references that Excel recognizes are generally updated with the new name.

Structured references can look unfamiliar at first, but they avoid having to extend a formula from, for example, B2:B100 to B2:B500 every time records are added. They also make intent clearer when a workbook contains several data lists. If you prefer ordinary cell references, you can still use them in a workbook that contains tables.

Sorting, filtering, and analyzing records

Each table header has a filter button. Use it to sort text alphabetically, sort numbers from smallest to largest, filter by a specific value, or apply available criteria such as a date range. A filter hides records that do not meet the criteria; it does not delete them. Clear the filter from the relevant header to show the full list again.

For example, a product table can be filtered to show only one region, then sorted by Amount from largest to smallest. The table’s records stay together when sorted, unlike sorting only one column in a way that could detach names from their corresponding values. Before sorting a normal range, verify that the whole record set is selected; table sorting handles the table rows as records.

A table can also be a source for a PivotTable or chart. Tables are convenient sources because additions to the table can be included when the PivotTable is refreshed, rather than relying on a range that was too short. A PivotTable does not necessarily update its displayed results instantly when source values change; refresh it to recalculate the summary.

Table maker options and alternatives

Excel’s built-in feature is usually the simplest option when the data is already in a workbook. You do not need an online converter or a separate add-in to create a basic table. An online table generator may be useful for producing a sample layout or a file in another format, but consider privacy before uploading business, customer, health, or other sensitive data to a third-party site.

If you only need a quick visual presentation, applying cell formatting may be enough. If you need filters, structured references, and automatic expansion, use an Excel table. If your goal is a summary rather than a record list, a PivotTable may be more suitable; it summarizes source data instead of replacing the original list.

You can remove table behavior without deleting the data by selecting a table cell and choosing Table Design > Convert to Range, then confirming the prompt. The cells remain in the worksheet, but table-specific features such as structured references and automatic expansion no longer apply. You can still keep existing cell formatting if desired.

Excel for the web also supports creating and working with tables, though the ribbon layout can differ from the Windows desktop application. Mac users can use the Insert > Table menu path; some keyboard shortcuts and dialog details differ between Mac and Windows. If a button is missing, first select a cell inside the table, since Table Design is a contextual tab and appears only when a table is selected.

Common table problems and fixes

  • The table includes the wrong range: Undo the conversion if it was just created, select the intended cells, and make the table again. For an existing table, use the resize option on Table Design and inspect the range before confirming.
  • Excel treats a data row as a header: Recreate the table with the correct header setting, or repair the header row. Put labels in the first row and keep record data below them.
  • A new row is not included: Check for a blank row or column between the table and the new data. Add the record directly below the last table row, or resize the table to include it.
  • A formula does not fill down: Check that the formula was entered in a table column and that the column is not mixed with unrelated manual values. A calculated column works best when every row uses the same formula pattern.
  • Sorting produces confusing results: Confirm that each record occupies one row and that there are no merged cells or blank separator rows in the data. Make sure values intended as numbers or dates are stored in a consistent format.
  • The table style is unwanted: Choose another style, turn off banded rows on Table Design, or use Convert to Range if table behavior is no longer needed.

Frequently Asked Questions

Is Excel table maker free?
Excel’s table feature is built into Excel, so there is no separate table-maker charge within the application. Access to Excel itself depends on the Microsoft 365 plan, license, or version you use.

What is the shortcut to make a table in Excel?
In Excel for Microsoft 365 on Windows, select the data and press Ctrl+T. The Insert > Table command is an alternative. On Mac, Insert > Table is a dependable menu route; available shortcuts can differ by version and keyboard settings.

How do I make a table with headers?
Include the header row when you select the data, create the table, and check My table has headers in the dialog. Excel then uses those labels as the table’s column names and places filter controls in the header row.

Can I turn an Excel table back into a normal range?
Yes. Select a cell in the table, choose Table Design > Convert to Range, and confirm. The data remains, but the range no longer has table-specific expansion, filter, or structured-reference behavior.

Why does my Excel table not expand automatically?
Automatic expansion usually depends on entering or pasting data directly beside the table. A blank row or column can interrupt the connection. Resize the table manually from Table Design if Excel does not include the new records.

Can I make a table in Excel for the web?
Yes. Excel for the web supports tables. Select the data and use the table command on the ribbon; its placement and appearance may differ from the Windows desktop version, but the core purpose is the same.

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.