Exam 77-420 Microsoft Excel 2013 3. Create Tables 3.1 Create a Table: Move Between Tables and Ranges (Convert to Range) Convert to Range This lesson began by creating a Table by selecting a Range of Cells. What if you wanted to remove the Table but keep the data? Here are the steps you can take to convert the table back to a Range, or List. Try it: Convert the Table to a Range Click anywhere on th.e Table. The Table Tools should be available. Go to Table Tools-> Design ->Tools. Click on Convert to Range. What Do You See? You will be prompted that the Table will be converted to a normal range. None of the data should be lost when you convert to Range.   The data will still have the Conditional Formatting, however the Filters at the top in the Header Row will be gone.   Done and done. You get the cookie.

Table Tools-> Design ->Tools-> Convert to Range