Section: Naming Ranges
...Subsection: Things to know about named ranges

Named ranges are always absolute references

There's no such thing as a named range that changed when used in a formula. This makes sense, if you think about it: you wouldn't want a single name referring to more than one place on the spreadsheet, or you'd get incredibly confused.

Named ranges can be any size

You can name as large or small a range as you like. In particular, you can name exactly one cell, which is a lot more useful than you might think.

You should almost always use a named range instead of an absolute cell address

Named ranges are absolute, and they're so much easier to read that you're almost always much better off using a named range.