00 353 1 2790020sales@olas.ie Olas: Professional, Direct, Clever & Helpful
Blog
Home / General / Cell/ Range Names

Cell/ Range Names

Cell/Range Names

In Microsoft Excel, the Name Manager is used to name an individual cell or a range of cells. The Name Manager can be found on the Formulas Tab. These range names can then be used in formulas to make them easier to create and understand. Cell names are treated as absolute references and will not change if you copy a formula to a new cell.

Define a Cell Name

• Select the cell to be named and click on the Name Manager option
• Click New and type a name (no spaces) and a comment (if needed)
• Click OK to confirm

Example:

Example of a range name “CommRate” used in a formula
Contact Us

Drop us a line, include your contact details and we will get back to you as soon as possible.