Sunday, 27 April 2014

Excel 2013: Removing a defined named range\data table

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.

No comments:

Post a Comment