[newbe]

I have a lot of data that I would like to manipulate using a table, but then I want to be able to remove the table. While I have no problem making the table (FORMAT AS TABLE), I have not been able to figure out how to remove the table once I am...

I have a lot of data that I would like to manipulate using a table, but then I want to be able to remove the table. While I have no problem making the table (FORMAT AS TABLE), I have not been able to figure out how to remove the table once I am done with it. If there is a way to do what I am looking for without tables, then that works. Here is my example:

AAA | BBBB | CCCCC
------------------------------------
Date | data | information
------------------------------------
2/13 | Ball | balls are red
2/14 | Cat | cats are pink
2/14 | Jason | uses a machete
2/14 | Cat | chopped up by jason

So, I can use a table so that I can select from the BBBB col and just select "cat". Then, I change the info so what I want, and then remove the table completely. Now I see the reason people dislike the ribbon, man E2003 was so much easier I use to just make a list, then, got rid of it if I was done with it. The help for Excel simply states to delete a table "On a worksheet, select a table. Press DELETE." Okay, yeah, wonderful if I want to get rid of the data, which I do not. As for clicking undo, well, that would undo the changes I did but want to save.

I can convert it to a range, but then the formatting is still there. Thanks for any help!