Forum Discussion

Copper Contributor

Jul 09, 2024

Solved

How can I remove all the names of cells without screws the spreadsheet?

Hi masters, I wanna remove all the names I've configurated converting on referral of cells. My spreadsheet has a lot names and needs to be more clean again. If I just remove all the names in Name...

excel

SergeiBaklan
Jul 09, 2024
Mister_Matt

You may try JKPieterse Free Name Manager Excel add-in (jkp-ads.com) or macros like here Convert formulas that use Named Ranges to use cell references - Microsoft Community

SergeiBaklan

Diamond Contributor

Jul 09, 2024

Mister_Matt

You may try JKPieterse Free Name Manager Excel add-in (jkp-ads.com) or macros like here Convert formulas that use Named Ranges to use cell references - Microsoft Community

Mister_Matt
Copper Contributor
Jul 09, 2024
Thank you Sergei !!!!
- SergeiBaklan
  Diamond Contributor
  Jul 09, 2024
  Mister_Matt , you are welcome.
  
  JKPieterse , when he is here, perhaps could give you much better advice.
  - JKPieterse
    Silver Contributor
    Jul 29, 2024
    You Are right SergeiBaklan, if you use our our Name Manager to delete names, it offers to replace the names in formulas with the address of te names.