Removing Names from Name Manager

R

Rob

Is there a way to remove all the Names in the Name Manager in one
stroke, as opposed to deleting them one by one?

I have a workbook with several sheet tabs and each tab has upwards of
20 defined 'Names'. When I copy this file all the names on

Thanks
 
P

Pete_UK

Click on the first name to select it. Hold down the <shift> key and
click on the last name, scrolling down if necessary. This will have
selected all the names. Then click on Delete to remove them in one
operation.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top