How to Change Excel Named Range

To change the excel name range open the Excel spreadsheet.

open excel spreadsheet

Click Insert.

click insert in the menu

Then select name.

select name in the dropdown

Then define.

click define under name

Select the name range you’d like to modify.

select your range

In the bottom box modify the range to your needs. Then click ok.

modify your range in box below and click okay

You’ve now changed the named range in excel.