Delete unnecessary Named Ranges

  • Thread starter Thread starter berniean
  • Start date Start date
B

berniean

I have a spreadsheet that has an incredibly long list of named ranges in the
Insert/Name/Define dialog that don't show in the Name Box. I don't know how
they got there and they refer to cells on spreadsheets on other people's hard
drives and network drives I don't have access to. I know how to delete them,
one by one, in the dialog, but is there a way to delete them as a group?

Thanks,
Bernie
 
Back
Top