Free Online Tutorials on Spreadsheets

Use names in formulas

Formulas become much easier to understand and maintain when we use names instead of cell/range references. For example, for clarity purpose, the range (A1:A5) in the formula: ‘SUM(A1:A5)’ can be named as ‘SUM(sale)’.

To use name in formulas, follow these steps:

1- Click a cell, having a formula and select the part of the formula that you want to name.

2- In the Formulas tab, go to the Defined Names section and click on the Use in Formula.

3- Select a name and press Enter.

Manage names in your workbook with Name Manager

To create, edit, delete and find all the available used names in the worksheet, open the Name Manage box by pressing Ctrl + F3. Or go to the Formulas tab, in the Defined Names section, select Name Manager.




Copyright © 2016 - 2019 Explainry.com | All Rights Reserved