When we work with PivotTables, sometimes we don’t want a spreadsheet to be a table any more. How to remove table format from it and convert it to a normal range? Below will show the way to achieve it in Excel 2013.
Step 1: Remove any table style
Select any cell in your targeted table till Design Tab appears under TABLE TOOLS. Choose the clear style as shown:
Step 2: Convert to a normal range
After converting a table to a normal range, you can delete the table without deleting represented data.
