To change the excel name range open the Excel spreadsheet.
Then select name.
Select the name range you’d like to modify.
In the bottom box modify the range to your needs. Then click ok.
You’ve now changed the named range in excel.