MS-Excel / General Formatting

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
[Previous] [Contents] [Next]

In this tutorial:

  1. Excel Table
  2. What is Table
  3. Create Tables
  4. Converting a Table to a Range
  5. Sorting Table Record
  6. Filtering Data in a Table
  7. Advanced Filter Command
  8. Working with the Total Row
  9. Applying a new style to a table
  10. Removing Duplicate Rows from a Table
  11. Selecting Table Areas
  12. Table Calculation
  13. Inserting, Moving and Deleting Table Rows and Columns