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 the 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.

Exam 77-882: Microsoft Excel 2010 Core 3. Formatting Cells and Worksheets 3.1. Apply and modify cell formats: Convert a Table to a Range Table Tools-> Design ->Tools-> Convert to Range