How to Remove the Table

%3CLINGO-SUB%20id%3D%22lingo-sub-1271244%22%20slang%3D%22en-US%22%3EHow%20to%20Remove%20the%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1271244%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20remove%20a%20table%20format%20without%20losing%20the%20data%3F%20All%20I%20want%20to%20keep%20is%20the%20data%20inside%20the%20table.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1271244%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1271408%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Remove%20the%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1271408%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403487%22%20target%3D%22_blank%22%3E%40Tim18283848585%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20useful%20reference%20for%20you.%20Scroll%20down%20to%20%2323%20on%20this%20list%20for%20the%20direct%20answer%20to%20your%20question.%20%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-tables%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fexcel-tables%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20take%20the%20time%20to%20acquaint%20yourself%20with%20the%20other%20pointers%20about%20Tables.%20You%20might%20even%20end%20up%20deciding%20to%20keep%20your%20data%20in%20that%20format.%20Fortunately%20(for%20you%20and%20me)%20you%20can%20recreate%20it%20as%20a%20Table%20after%20%22un-tabling%22%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEnjoy%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

1 Reply
Highlighted

@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