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
Problems with formating text within a cell.
Maciej Fox in Excel on
10 Replies
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
reverse text to columns for .csv import
milly87 in Excel on
3 Replies