Excel allows us to convert a table to a range without losing the table style. A range means a regular set of data on the worksheet. This tutorial will walk all levels of Excel users through the easy steps of converting a table to a range while keeping all table style formatting.

Figure 1 – Converted table to range

Data to Convert Table to Range

Before we can convert the table to a normal range, we must have created it. The table is created by clicking any cell within the range, clicking on the Insert tab, and clicking on Table.

Figure 2 – Data to convert the table to a normal range

How to Convert a Table to a Range

We will do the following to convert table to a range.

  • We will click any cell on the table
  • We will go to the Design tab. We will click Convert to Range in the Tools group. On a Mac, we will do this on the Table tab.

Figure 3 – Click Convert to Range

  • We will receive a prompt. We will click Yes

Figure 4 – Click Yes

  • We will notice that the arrows on Row 3 will disappear

Figure 5 – Converted table to range

Alternative Method to Convert a Table to a Range

  • We will right-click on the table
  • We will click Table
  • We will click Convert to Range


After we have converted to a normal range, the table functionalities such as the row headers and sort and filter arrows become unavailable.