Home

Convert Table to Text

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

 

Highlighted
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