PDF download Download Article
Quickly delete or clear formatted tables in Excel using desktop or mobile
PDF download Download Article

Do you want to remove a table in Microsoft Excel? If you have any unwanted formatting, you can easily clear it with the "Clear" tool. If you want to convert a table back to a range of data, you can use the "Convert to Range" tool. This will delete the table while keeping all your important data. This wikiHow will show you how to remove table formatting in Microsoft Excel using your Windows or Mac computer, iPhone, or Android device.

Things You Should Know

  • Highlight the table you want to change. Click "Home" → "Format as Table" → "Clear".
  • To remove the table, highlight the table → "Table Design" → "Convert to Range" → "Yes".
  • On mobile, highlight the table → "Home" → "Table" → "Convert to Range".
Method 1
Method 1 of 2:

Using Desktop

PDF download Download Article
  1. You can use an existing project or create a new spreadsheet . [1]
  2. Click the top-left corner of the table and drag the cursor to the bottom-right corner. This will select all the cells within the table.
    Advertisement
  3. You can find this on the top toolbar, next to Insert . You may already be on this tab.
  4. This will be in the Styles section. A drop-down menu will open.
  5. This will be at the bottom of the drop-down menu.
    • On some devices, you can find the Clear icon in the Editing section. This looks like a pink eraser icon. Tap Clear , and then tap Clear Formats .
    • The table's formatting will be removed.
  6. If you want to remove the entire table rather than just the style, you can convert the table into a range of data. [2] Do the following:
    • Highlight the table.
    • Click the Table Design tab.
    • In the "Tools" section, click Convert to Range .
    • Click Yes .
    • The table will be converted.
  7. Advertisement
Method 2
Method 2 of 2:

Using Mobile

PDF download Download Article
  1. The app looks like an x on top of a green rectangle.
    • Microsoft Excel is available on iOS and Android.
  2. Tap the cell in the top-left corner of the table, and then drag the right circle to the cell at the bottom-right corner. This will select all the cells within the table.
  3. If you don't see the menu, tap the icon of the A in front of a pencil.
  4. This will be at the very bottom of the list.
  5. The table will be converted into a range of data. You can now remove the formatting.
  6. You may have been redirected to this tab.
  7. This will be towards the bottom of the Home tab.
  8. The table's formatting will be removed.
  9. Advertisement

Expert Q&A

Ask a Question
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Thanks for submitting a tip for review!

      About This Article

      Thanks to all authors for creating a page that has been read 15,759 times.

      Is this article up to date?

      Advertisement