How to Remove the Table

Copper 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

@Tim18283848585 

 

Here's a useful reference for you. Scroll down to #23 on this list for the direct answer to your question. https://exceljet.net/excel-tables

 

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.

 

Enjoy

Any chances you have a solution for web version?

@gen_shines_again 

 

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.

@gen_shines_again 

Same is in Excel for web

image.png