Share via

Excel for Mac: Delete a table

Anonymous
2019-02-27T18:09:19+00:00

How to I delete a table? Simply convert it to a range?

Is there a list of tables that have been created in a given workbook?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Bob Jones AKA CyberTaz MVP 430.2K Reputation points
    2019-02-27T18:28:50+00:00

    When Table is applied to a range it is given the equivalent of a Range Name starting with "Table1". That name, however can be changed on the Table tab of the Ribbon.

    Since they're treated as Named Ranges the name of Tables appear in the Name Box @ the left end of the Formula Bar.

    As for the delete part of your question: It depends on exactly what you want to delete...

    If you simply want to remove the Table effects/features use the Convert to Range tool on the Table tab. It also may be necessary to remove the formatting separately.

    If you do want to delete the actual data you can do so just as with any other range of cells by selecting the rage & using Edit> Clear> All.

    6 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-02-27T18:34:20+00:00

    Hi Kerry,

    Yes, you could click Convert it to a range to remove the table format in Excel. You could try typing table to find an Excel template containing multiple tables you desired in New page.

    Regards,

    Eli

    0 comments
  2. Anonymous
    2019-02-27T19:19:49+00:00

    Thank you both for responding.

    0 comments