Name column: reference a column by name to make the formula easier to understand.Next, we will continue with the previous example.
1. historical issuesAlthough the numbers are compiled into named cells, there are still cells such as B2 and C2. To understand the formula, you need to find the corresponding column title. Especially if the formula below is filled with numbers and cell address references, it will be a headache for anyone who sees them. Next we will introduce how to solve the cell address problem in the formula.
2. Create a tableSelect a cell in the data area and press Ctrl + T. Excel selects the entire data area and the following dialog box is displayed. The data area contains the title, so you need to check "table includes the title" and click "OK. The data zone will become a little more beautiful than before and can be filtered. However, if the table is beautiful, it cannot solve the formula problem. Let's continue.
3. Name Reference column.Go to the edit column, and enter square brackets. The Column Titles are automatically listed below. Change the formula to the following: during the input formula, you can see that the entire column corresponding to the name is selected for each color box, rather than the cell. Such a formula can be understood without explanation. It is very tall and elegant ~~
Square brackets use the entire column of data instead of independent cells. After entering the formula, press Enter. The formula for all cells in the overtime column is the same. In this way, if the column name changes, the column name in the formula will also be modified simultaneously. Even if columns B and C are interchangeable, you do not need to modify the formula because the column name remains unchanged.
TipsMove a column or row as a whole: select a column or row, hold down shift, move the cursor to the border of the selected column or row, and drag the left mouse button to the specified position.
4. Formula EvaluationThe formula evaluate has nothing to do with the name column. Here we will share it as a practical technique. Select a cell with a formula, and then locate formula. For example, click formula evaluation. The following window is displayed. Click the evaluate button each time, excel calculates the value of an element in the formula. For complex formulas, you can check the calculation process of each step in this way. This topic describes how to reference columns in other tables by naming columns in the same table.
Excel should be like this-2. Name Columns
