Using Formulas and Functions in Microsoft Excel 2013
- 4/15/2013
- Creating simple cell formulas
- Assigning names to groups of cells
- Using names in formulas
- Creating a formula that references values in an Excel table
- Creating formulas that reference cells in other workbooks
- Changing links to different workbooks
- Analyzing data by using the Quick Analysis lens
- Summing a group of cells without using a formula
- Creating a summary formula
- Summing with subtotals and grand totals
- Exploring the Excel function library
- Using the IF function
- Checking formula references
- Debugging your formulas
Assigning names to groups of cells
When you work with large amounts of data, it’s easy to lose track of which cells contain which data. In addition, it can be difficult to locate data in workbooks that you didn’t create. Although you might always store product prices in one worksheet column, there’s no guarantee that your colleagues will follow the same pattern! One way to prevent confusion is to define a named range for any cell group that holds specific information. For example, in a worksheet with customer order data, you can define the Totals named range to represent the cells in which the total for each order is stored. After you define the named range, you can display its contents, rename it, or delete it.
Create a named range
Select the cells that you want to name.
Click the Name Box on the formula bar.
Type the name that you want for the range.
Press Enter.
Go to a named range
Click the Name Box down arrow.
Click the range to which you want to go.
Delete a named range
Click the Formulas tab.
Click Name Manager.
Click the named range that you want to delete.
Click Delete.
Click OK to clear the confirmation dialog box that appears.
Click Close.
)
Rename a named range
Click the Formulas tab.
Click Name Manager.
Click the named range that you want to rename.
Click Edit.
Type a new name for the range.
Click OK.
Close the Name Manager dialog box.
