Quick Links
Summary
Named ranges are a common feature of spreadsheet software.
But its quite possible you havent even heard of them, despite their usefulness.
What Are Named Ranges in Google Sheets?
Satheesh Sankaran/Shutterstock
A named range is a bit like a variable in programming.
The feature is not very well known, but is present in mostspreadsheet software, including Microsoft Excel.
Named ranges have several benefits.
you could also use named ranges for maintainability.
Then, every formula that refers to payments will be up-to-date.
How Do You Use a Named Range?
There are various rules about which characters it’s possible for you to use in your names.
Stick to a-z letters without punctuation, and you shouldnt have any problems.
Create a Named Range
After you bang out the name, ensure to pressEnter.
Clicking out of the box will cancel the named range.
double-check your named range exists before you take a stab at use it in a formula.
Simply opt for range and change the value in the Name box.
If you rename a range, Sheets will automatically update any formulas that use it.
If you need a quick overview, just run with this.
you’re able to alsoAdd a rangeor delete one using theNamed rangespanel.
