For normally defined name:
1) Formulas menu.
2) Name Manager.
3) Select the range and delete.
In my case that was a result of a query which generated the named data table:
1) Select the range from the drop down list beside the formula bar.
2) Right click on any cell within that range, and select:
Table --> Convert to Range
The reason I wanted to get rid of that named table in the first place was that filtering and sorting the data inside it was separated from the main sheet.
1) Formulas menu.
2) Name Manager.
3) Select the range and delete.
In my case that was a result of a query which generated the named data table:
1) Select the range from the drop down list beside the formula bar.
2) Right click on any cell within that range, and select:
Table --> Convert to Range
The reason I wanted to get rid of that named table in the first place was that filtering and sorting the data inside it was separated from the main sheet.
No comments:
Post a Comment