In this article, you will learn the Named Range and how to use it in Google Sheets.
The Named Range is one of the functions in Google Sheets, which allows you to give a name to a range or an array, and use the name (as a substitute for cell reference) in a formula. For instance, assume you have a formula such as “=SUM(B2:B6)”. If you name the range of B2:B6 as “sample” and register it, the SUM formula with the named range, “=SUM(sample)”, works properly. Thus, this function is beneficial when you repeatedly refer to a specific range or array in your formulas for your work.
Steps 1 and 2
Steps 3 to 5
What you need to bear in mind when you name a range are as follows
See how the Named Ranges work on a worksheet by looking at examples.
The first example shows how to use a Named Range representing a cell. We named cell C3 “mil”. This cell is to unit conversion. In cell E3, we want to show five million. So, we need to multiply 5 by 1,000,000, when you can use the named range. You can type “=5*mil”, and the “mil” part refers to the value contained in “mil” (cell C3). Thus, you get 5*1,000,000=5,000,000 in cell E3 as a result.
The other examples in the picture above show how to use a Named Range for a range.
As you can see, we named a range of cells (C7:C18) “Revenue2022”. You can input this name instead of a cell reference in each formula. These examples are relatively simple, so you may feel that you don’t need to set a named range. However, if you have a much larger data set and need to run an analysis with various formulas, the Named Range function benefits you for sure.
Lastly, learn the pros and cons of the Named Ranges in the section below.
Pros
The Named Ranges:
Cons
The Named Ranges:
Are you learning this tip to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows and update numbers in real-time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. You can also customize these templates as you want without breaking the automated data inflow.
To learn more about LiveFlow, book a demo.
If you don’t get the solution to your question in this article or you are interested in learning the other advanced tips in Google Sheets, you may find the answers in the following articles.
Check the following articles to use Google Sheets more efficiently.
How to Find and Replace Words in Google Sheets
How to Enable Excel Shortcuts in Google Sheets
Relative Reference and Absolute Reference in Google Sheets: Explained
Read the articles below to organize your data in Google Sheets.
How to Remove Duplicates in Google Sheets
Pivot Table in Google Sheets: Explained
Go to the following pots to learn how to create a pull-down menu or limit data input in a cell.
Drop Down List in Google Sheets: Explained
Dependent Drop-down List in Google Sheets: Explained
How to Use Data Validation in Google Sheets
Do you want to learn how to use Google Data Studio? Navigate to the article below.
You can learn about other Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides
Learn how to do this step-by-step in the video below 👇