Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 703
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 26
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to delete names on worksheet? GOH Excel Discussion (Misc queries) 9 May 22nd 08 03:38 PM
Delete defined names beata Excel Discussion (Misc queries) 1 January 7th 08 09:44 PM
Delete names from a list ClemCadidlhoper Excel Discussion (Misc queries) 15 January 5th 06 10:50 PM
How to delete all defined names from a workbook? Dmitry Kopnichev Excel Worksheet Functions 15 November 14th 05 03:26 PM
delete duplicate names in a column jaya New Users to Excel 1 October 21st 05 09:53 AM


All times are GMT +1. The time now is 10:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"