ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Delete Table Names (https://www.excelbanter.com/new-users-excel/190039-delete-table-names.html)

Treasur2

Delete Table Names
 
I've been given a workbook. It has a long list (20+) table names in it. I
want to delte them. When I go to name manager, select any table name, the
delete button i s greyed out.

I've double checked that my workbook, and worksheet(s) are not protected.

Any ideas.

I'd even be willing to delete them one at a time, any other way.

Per Jessen[_2_]

Delete Table Names
 
On 5 Jun., 00:11, Treasur2 wrote:
I've been given a workbook. It has a long list (20+) table names in it. *I
want to delte them. When I go to name manager, select any table name, the
delete button i s greyed out.

I've double checked that my workbook, and worksheet(s) are not protected. *

Any ideas.

I'd even be willing to delete them one at a time, any other way.


Hi

Maybe the sheet is protected.

If that is the case you will have to unprotect the sheet before
deleting the names.

Regards,
Per

J Sedoff[_2_]

Delete Table Names
 
If you are trying to delete tabs/sheets, then select those multiple tabs
either using "Shift" or "Ctrl" ("Shift" will select a consecutive group of
sheets; "Ctrl" allows you to select a non-consecutive group of sheets),
right-click and select "Delete."

Hope this helps, Jim


All times are GMT +1. The time now is 04:32 AM.

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