Name Manager

This can be accessed from the Formulas tab, Defined Names group
This can be used to add, edit and delete named ranges
This was introduced in Excel 2007 to replace the earlier Define Name dialog box.
This provides a complete list of all the named ranges in the active workbook.
Whether a named range is a worksheet level or workbook level is indicated in the scope column.
The name manager includes their Value, the Range and the Scope
Any named ranges created using the Name Box have a workbook scope and can be accessed from any worksheet within the workbook.

When you type a named range into a formula the cell that it refers to is automatically highlighted
Double clicking on the named ranges ?

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext