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.