Home

Convert Table to Text

Highlighted
Miriam_Ferber1
New Contributor

How do I remove the table and convert it to text in Excel 2016? 

2 Replies

You need to select any cell in the table so the "Table Tools Design" tab is shown.

Then select "Convert to Range" from the "Table Tools Design" tab.

 

converttorange.jpg

 

I wasn't sure whether the cells were part of a table as I did not create this sheet. I was told it was a table but could not see table attributes.
I then marked the cells and so I could creat a table. Then I followed your instructions. This solved the issue.
Thank you.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies