When you work with an Excel data sheet with multiple columns of information, the Define Name feature helps us name that column of information. This feature will help you name a cell, a data area or an array of data in an Excel table. When executing a formula, users can use the names of cells and direct ranges. If we move the named range, Excel will automatically update the formula with the named data area.
So the calculation of data on Excek will be faster and more accurate, the formula is shorter and easier to understand. The following article will guide you how to name the data area in Excel.
1. Instructions for naming a range of cells in Excel
Step 1:
In the data table you are working click on the column you want to name and then select the Formulas tab in the toolbar, then select the Define Name as shown below.
Step 2:
In the new dialog box that appears then there will be items to select content.
Click OK to set up.
Then the set names will be in the Use in Formula section in the Formulas tab.
2. Name the ranges from an Excel data area
This way we will name multiple columns or multiple rows at once.
Step 1:
We select the cells we want to name for the whole range including the title, the title of the title will be the name of the sequence. Click on the Formulas tab and click on Create from Selection .
Step 2:
In the new dialog box interface, users will have more options:
When we check, we will also see the data area name has been successfully set.
3. View and delete names that have been placed on Excel
To review the set names, click Use in Formula or Name Manager in the Formulas tab.
In case you want to delete, edit or create new content in the created range, click on Fromulas tab , select Name Manager . In the Name Manager interface box, click on the data set to create the name and the following options will appear.
When clicking on the Edit item, users can change the set range name, select the named data area. In Scope alone, we cannot replace the scope of the range.
When you name the cells or data areas on Excecl, it is easier to remember the corresponding cell addresses. The implementation of the formula through the naming sequence is also faster. But users should note that the name must be less than 155 characters and do not use spaces, no symbols, except dots and underscores.
See more:
I wish you all success!
ncG1vNJzZmismaXArq3KnmWcp51ktbDDjK2mZqaRorJurYycnKWkXaS%2FbrHXnJylZZSWwaJ5wKucmg%3D%3D