ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i delete a table without loosing my data? (https://www.excelbanter.com/excel-discussion-misc-queries/209243-how-do-i-delete-table-without-loosing-my-data.html)

benk

how do i delete a table without loosing my data?
 
I enetered data in multiple rows and columns. I clicked on the "format as
table" in the "home" tab and now i can only get to my data through the drop
down list in the table. Is there a way to delete the table without loosing
my data?

Sheeloo[_3_]

how do i delete a table without loosing my data?
 
There should be an option called 'Convert to Range'

Do make a copy of your workbook before trying this...

"benk" wrote:

I enetered data in multiple rows and columns. I clicked on the "format as
table" in the "home" tab and now i can only get to my data through the drop
down list in the table. Is there a way to delete the table without loosing
my data?



All times are GMT +1. The time now is 04:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com