Excel Tables With Multiple Sections: Layouts and Limits

How-to basics · Updated November 18, 2026

An Excel Table is designed for one continuous dataset, not several separately headed sections inside the same table. To organize different groups, either add a category column to one table when the records share the same fields, or create a separate table for each genuinely different dataset.

What “multiple sections” means in Excel

People use “sections” to describe several different worksheet layouts. You might mean blocks of records separated by blank rows, monthly groups with repeated headings, categories such as East and West, or distinct schedules with different columns. The right layout depends on whether those blocks are really parts of one dataset or independent lists.

An Excel Table is a specific feature, not just a range that has colored formatting. It has one header row and a contiguous body of records. Excel uses that structure for built-in filtering, sorting, automatic expansion, calculated columns, and structured references. A blank row or a second heading in the middle does not create a new section that the table understands; it becomes part of the table’s rows or disrupts its continuous data structure.

By contrast, a worksheet can contain many separate tables and ordinary formatted ranges. You can arrange them vertically or side by side, provided their ranges do not overlap. Thinking of a worksheet as a page and each Excel Table as a separate data object resolves much of the confusion.

When one table with a category column works best

Use one table when every record has the same kind of fields, even if the records belong to different groups. For example, instead of creating separate January, February, and March blocks, make one sales table with columns such as Date, Month, Product, Region, and Amount. Each sale gets its own row, and the Month or Region column identifies its group.

This is usually the most useful structure for data you expect to sort, filter, summarize, or chart. It avoids repeated headers and empty separator rows, and it lets Excel treat each row consistently. A filter on Region can show only East records without moving them into a separate section. You can also add a new month by adding rows, rather than copying a formatted block and hoping its formulas and ranges remain consistent.

A practical rule is that a column should describe one attribute and a row should describe one record. Avoid using section labels as standalone rows within the data. If a label such as “West Region” applies to a group of records, repeat “West” in the Region field for each applicable record. Repetition in a category column is useful data; a decorative heading embedded among records is not a substitute for it.

  • Use one table: the groups have the same columns and each row represents the same kind of item.
  • Add a group field: records need to be distinguished by month, team, location, product type, or another consistent category.
  • Keep one header row: column names belong at the top of the table, not repeated between groups.

When separate tables are the better choice

Separate Excel Tables make sense when the blocks represent different kinds of information or have different fields. For example, an inventory list with SKU, Stock, and Reorder Level is not the same dataset as a supplier contact list with Company, Contact, and Phone. Forcing both into one table would require unrelated columns, mostly blank cells, or ambiguous headings.

You can create each table as its own object on the same worksheet. Give each a clear heading outside the table, then leave a blank row or column between table ranges to make the layout easier to read and reduce the chance that new data will be mistaken for an extension of a nearby range. The heading above a table is a worksheet label, not part of the table’s header row.

Separate tables have independent filters and can have different column names. They also need distinct table names within the workbook. Select a cell in a table and use the Table Design tab to view or change its name in the Table Name box. Descriptive names such as Inventory and Suppliers are easier to recognize in formulas than default names such as Table1 and Table2.

Do not choose separate tables solely because you want visual gaps between categories. If the records have the same fields, one table with a category column will generally be simpler to maintain and analyze. Separate blocks can be appropriate for a presentation sheet, but they are less convenient as a source for combined analysis.

How to create a table for each section

In Excel for Microsoft 365 on Windows, select a cell in the first data range and choose Insert > Table, or press Ctrl+T. Check that the proposed range contains just that section, select My table has headers if its first row contains field names, and confirm. Repeat for each independent range. On Excel for Mac, use Insert > Table or the Command+T shortcut; dialog wording can vary slightly by release.

  1. Put a single row of clear, unique column headings at the top of each dataset.
  2. Remove decorative title rows, merged cells, and blank separator rows from the data range before making the table.
  3. Create the first table, confirm the range, and check that Excel has recognized the correct headers.
  4. Repeat for the other sections, keeping the resulting table ranges separate and non-overlapping.
  5. Rename each table from Table Design > Table Name so its purpose is clear.

For a worksheet intended mainly for reading or printing, you can place a title above each table and apply formatting separately. Keep titles outside the table because a table has one header row, and its filter controls attach to that row. If you want a formatted section that is not meant to behave like a data object, a normal cell range with borders and fills may be a better fit than an Excel Table.

What happens with blank rows, repeated headers, and subtotals

A blank row inside a table is not a reliable section break. It is still a row in the table, and it can complicate filtering, formulas, and exports. Likewise, putting a heading such as “Quarter 2” in the middle of a table does not make Excel treat the following rows as a separate dataset. Sorting the table may move that heading away from the records it was intended to label.

Repeated header rows create a similar problem. Excel Tables use one header row for all records. A repeated heading within the body is treated as data, not as a second set of column labels. Table headings should also be clear and unique; avoid merged header cells or multi-row headings if you need table features such as filters and structured references.

If you need a single overall total, the table’s Total Row can be enabled from Table Design > Total Row. It provides summary choices for columns, but it is not a way to insert subtotal rows between categories. For subtotals by month, region, or another field, keep the source data in one continuous table and build a PivotTable or a separate summary report. That keeps the underlying records sortable and filterable.

For a polished report with several labeled sections, it is often sensible to separate the data-entry structure from the display structure: store records in one well-formed table, then present totals or selected details in a report area or another worksheet. A report can have headings and visual breaks without making the source data harder to analyze.

Choosing a layout for common examples

Consider a project tracker with tasks for several departments. If every task has Task, Owner, Due Date, Status, and Department fields, put all tasks in one table and use Department as a column. That makes it straightforward to filter for a department or sort all tasks by due date. Creating a separate table for each department would duplicate the same structure and make an all-department summary harder.

Now consider a worksheet containing a staff directory and a list of office equipment. The fields do not describe the same type of record, so separate tables are more natural. A combined table would need fields such as Employee Name and Asset Serial Number, with many blank cells and unclear meaning.

For a monthly budget report, distinguish the source from the presentation. If monthly entries share the same fields, record them in one table with a date or month field. If a reader needs a page with a separate block for each month, create that display from the shared source rather than treating the repeated blocks as the main data store. If the blocks are fixed, small, and only for display, ordinary ranges may be entirely adequate.

  • Same fields, more categories: one table plus a category column.
  • Different record types or fields: separate tables.
  • Visual sections for a report: one clean source table and a separate presentation layout, or ordinary formatted ranges.

Tables compared with ordinary ranges and PivotTables

An Excel Table is useful when people will maintain a list of records. Its filters, consistent formatting, and automatic extension make it more dependable than a manually styled range for ongoing data entry. It is not, however, a general-purpose page-layout tool. If the goal is to place several unrelated blocks on a printable form, ordinary ranges give you more freedom to use custom titles, spacing, and merged cells.

A PivotTable is a summary tool, not a replacement for the source list. It can arrange and summarize records by fields such as month, region, or product, which is helpful when the reader wants grouped results or subtotals. A common arrangement is one source Excel Table with one or more PivotTables on a report sheet. When the source data changes, refresh the PivotTable to update its summary.

These tools can coexist: use tables for clean source datasets, and use formatted cells, charts, or PivotTables to present information in sections. Choosing the right object for each job is more robust than trying to make one table act like a database, a report, and a form at once.

Frequently Asked Questions

Can one Excel Table have two header rows?
No. An Excel Table has one header row. You can put a title above the table, but a second heading row within the table body is treated as data rather than another header.

Can I put blank rows between sections in one table?
You can have blank cells or rows in a table, but they do not create independent sections. They can interfere with sorting and summaries, so use a category column or make separate tables instead.

Can I place multiple Excel Tables on one worksheet?
Yes. Each table needs its own non-overlapping range. Leave a visible gap between them, and give each table a distinct name so they are easy to identify.

Should I make one table per month?
If every month contains the same fields, one table with a date or month column is usually easier to filter and summarize. Separate monthly tables may suit a fixed presentation, but they are less convenient for analyzing all months together.

How do I show subtotals for different sections?
Keep the detailed records in a continuous table and summarize them by category with a PivotTable or a separate report. The table’s Total Row is for a table-level summary, not subtotal rows between groups.

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.