How to Remove the Table

New Contributor

How do I remove a table format without losing the data? All I want to keep is the data inside the table.

4 Replies



Here's a useful reference for you. Scroll down to #23 on this list for the direct answer to your question.


But take the time to acquaint yourself with the other pointers about Tables. You might even end up deciding to keep your data in that format. Fortunately (for you and me) you can recreate it as a Table after "un-tabling" it.



Any chances you have a solution for web version?



Did the reference above not work? Did you try it?


I never have used the web version of Excel, so don't know anything at all first hand. I had to do research to answer that first question.


Same is in Excel for web