convert the data into TABLE without headers and filters.

Question

Hello I want to convert the data into TABLE without headers and filters.

The content of the data is also having FILTER formulas which collect data from differents sheets.

Answer 1

Excel tables always include table functionality such as headers and filter drop-downs. If a table style is applied, Excel creates an Excel table automatically.

If the goal is to keep the table-style formatting but remove headers and filters as table features, use this approach:

1. Select the data range.
2. On the Home tab, select Format as Table and choose the style.
3. Click anywhere in the new table.
4. Go to Table Design on the Ribbon. On Mac, go to the Table tab.
5. Select Convert to Range.
6. Confirm with Yes.

Result:

• The formatting remains.
• The data becomes a normal range.
• Table features are removed, including filter arrows.
• Structured references in formulas are converted to regular cell references.

If the data is produced by FILTER formulas from different sheets, keeping it as a normal range is the supported way to avoid table features while preserving the displayed results and formatting.

---

References:

• Convert an Excel table to a range of data
• Apply a table style without inserting an Excel table