So you want to edit a named range 's range , meaning we don't want to change the name, we don't want to delete it, we just want to change the range in which it is looking at. For instance, here with A2 to A9, we have invoice IDs, but we've added a 10th one, so we actually want to edit this to include the 10th row here, but maybe even more. So we want to edit this named range . Here's how to do that. You could go to anywhere in the sheet, but And click Data , Named Ranges , and you'll see a list on the right of all the named ranges . So our named range you want to edit is Invoice IDs. Go over to the right side, click Edit. And we can edit the name here, but we can also edit the range. And in my case, I just want to do a two to a click done.

And now that will include every single row in this sheet. That's how to edit a named ranges and range . If you're looking for more about named ranges and how to use them and why go watch this other video on YouTube here on better sheets and subscribe. Better Sheets Videos Checklist Google Sheets Error: Unknown Range Name and How to Fix it Better Sheets Videos Checklist How To Reference Another Spreadsheet in Google Sheets