How to use Named Ranges in Google Sheets

If you're working with lots of data, you're probably updating it regualrly. Named Ranges can help make sure that you "referenced cells" don't get messed up. You can find this option under the "Data" option in the menu bar.

When you have a Named Range, you can use it within your Formulas by typing it into the formulas directly as if it were a value - like this:

If you did it correctly, the result will look like this:

Because you're using a Named Range, the formula won't break if you move the values around or update the underlying data. If you move your Named Range from column A:A to M:M, any formulas referencing the named range will still work. It's also really nice to use Named Ranges because it is more readable - making it easier to work on a single spreadsheet as a team.

Common Use Cases

• Defining a dynamic range of data that will be used in different formulas - e.g. Revenue, Impressions, Clicks, etc
• Making your formulas more readeable. Let's face it, seeing a formula that says Impressions is easier to understand than 'googleadsdataexport01152021'!H:H
• Making it easier to manage your Data Validation settings