To convert a table to the data range, please see steps below:
Step 1. Click anywhere in the table;
Step 2. Click the "Design" tab or "Table Design" tab from the Ribbon (depending on your Excel version);
Step 3: Click "Convert to Range" in the "Tools" section;
Step 4. Click "Yes" in the new window to confirm;
Step 5: The table will turn into data range without losing data or formatting.
