Exceltechie.com

Easiest way to learn excel on the planet
Facebook-exceltechie Twitter-exceltechie Linkedin-exceltechie
|| Novice || Beginner || Intermediate || Advanced || Specialist || Expert ||
List of Features
Name Manager

Understanding Name Manager
Select a Column Range and Click Formula-> Name Manager

Name Manager contains Named Range and Named Constants
Named Range
This is a range of Cells. When you select these cells you can see the name populating in the Top left Name Box of excel sheet

Named Constants
This refers to a single cell . You can name a cell and use this name instead of references
Example: Instead of C4* A1 , You may name A1 as Conversion_Rate and say C4* Conversion rate for better understanding.
Shortcut  [Ctrl]+F3