Remove excel table

Question

Want to remove a table that is no lobger needed

Answer 1

Do you want to get rid of the table definition and all of the data:

if there is just the table data on the rows, select all of the rows, right click and delete the rows.

If you want to keep the data, but get rid of the table definition:

• With the insertion point inside the table the "contextual" Table tab will display
• in the Table Styles group click on the Styles gallery
• Click on the "none" style in the upper right corner of the gallery to remove all formatting
• In the Tools group click on the "Convert to Range"" button
• 

This will remove the table definition, converting the table into "normal" data.

Answer 2

You have to click inside the table to give it focus so the contextual tab will display.

.

Simply hovering over the table will not work.

Answer 3

when the cursor is within the table, no other menu appears?

Answer 4

Ron:

Still want to retain the workbook, just delete the table.

Answer 5

Why can't you right click on it in File Explorer and click on delete?