Converting a Table to a Range

If you no longer need to work with a table, you can convert the table to a normal range.

Right-click in the table and choose Table> Convert to Range from the contextual menu or click anywhere in the table and then click Convert to Range in the Table Tools Design tab.

Following more sections:

• Sorting Table Record
• Filtering Data in a Table
• Advanced Filter Command
• Working with the Total Row
• Applying a new style to a table
• Removing Duplicate Rows from a Table
• Selecting Table Areas
• Table Calculation
• Inserting, Moving and Deleting Table Rows and Columns