9

I have created an excel table. However, I now want to delete or change it because my range changed.

However I can't delete it in the excel Name Manager:

enter image description here

Any suggestion why I cannot delete it?

Would appreciate your answer!

Improve this question
4
  • How about delete it as a range? Look for it in your sheet (it should be in Sheet 'RawData' and you delete manually from there.
    – Jerry
    Commented Apr 8, 2014 at 6:34
  • @Jerry Thx for your answer! What do you exactly mean by deleting it as a range.
    – Carol.Kar
    Commented Apr 8, 2014 at 6:48
  • I meant like selecting the table range from A2 to J something (I can't see the whole range) and then press delete (or to delete it completely, Ctrl+-.
    – Jerry
    Commented Apr 8, 2014 at 7:08
  • Select headers, right click the cells and select Remove Columns
    – user222864
    Commented Apr 8, 2014 at 7:24

3 Answers 3

Reset to default
13

Highlight all of the cells in the table (and only those cells) then click the Convert to Range button in the Table Tools/Design tab (screenshot below).

Now that this data is no longer grouped as a table, it will appear in the Name Manager as separate columns/rows (depending on how you defined the range) with the delete button no longer greyed out.

enter image description here

Improve this answer
1
  • Works like a charm 😍
    – m3dl
    Commented May 10, 2021 at 15:08
2

As I understand, in Excel 2010 (Windows), you cannot delete a table using the Names Manager. Your only option here is to pick any cell or select the existing table name (eg Table1, Table2, Table3, etc.) and convert the table back to a range. One you have done this, the table will disappear from the names manager. Then you can go ahead and create a new table.

Improve this answer
0

If the Tools features are not enabled, check to see if there are two (or more) tables on the same tab. Excel will disable the ability to delete a column if there is more than one table, but you can delete the cells in each table one at a time.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .