Lesson 23: Named ranges in Google Sheets (alternative method to lesson 23)

Note: This lesson presents an alternative way of working with ranges, so repeats the steps we did in the last lecture but using a better technique.

This lesson covers adding the UNIQUE() formulas to create the lists required for the data validation. We did this at the end of the last lesson, so what's going on here?

Well, I'm going to show you an alternative, and arguably, better way of working with ranges in spreadsheets by giving them names and then using these names in your formulas.

So clear out the lists from the previous lecture and have a go setting them up with named ranges.

Learning Objectives for this lesson:

  • Understand and apply named ranges in Google Sheets


Link to official Google documentation on Named Ranges