How to Convert a Table to the Data Range

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.

Leave a Reply