Forum Discussion
Clinton Azotea
May 15, 2018Copper Contributor
Table will not convert to range
I am trying to convert a Table to a normal range. I right click on the table and choose "Table>Convert to Range" . After selecting "yes" the data remains unchanged in a Table format. Are there any ...
John Jairo Vergara DomÃnguez
May 16, 2018Brass Contributor
Hi, Clinton! One thing is the table as an object and another thing is the table format. When you convert a table into a normal range, the format of the table in the cells is maintained, but the dynamic properties of the table are lost. There are at least three ways to identify if a range is a table: 1. When you stop in any cell of it, the table tools appear at the top right, on the ribbon. 2. If you go to the bottom right of the table, you see a kind of triangle, which is used to manually resize the size of the table. 3. When you are standing in a table, and you are several records down until you can not see the titles of the table, Excel column titles are replaced by the titles of the table. If you convert by the procedure that you comment a table in a normal range, you will not see any of the three named characteristics. Blessings!