Name Manager
now browsing by tag
AcroForms
add controls to form
Arbitration
Autoexpand
BookMarks
defined tables
Dynamic Hyperlinks
enable macros
Excel
Excel 1013
excel 2007
excel 2010
excel 2013
Excel Defined Names
Excel Linear Interpolation
Excel ScoreBoard
excel to pdf
excel userform
excel vba form
expand userform
Export XML Data From Excel
fill combo
Header Row
hide excel sheets
Mail Merge
Map Excel to Word
Mass Metters
PDF Form
pdf to excel
Ping Pong
protect sheet
range to array
Table Components
tables
Table Tennis
TextBox
TextBox Change Event
TextBox Exit Event
Totals Row
UDF
VBA Interpolate
vba user form
workbook protection
XFA Forms
XML Data
Working With a Defined Name
What is a Defined Name?
In Excel, you have the option to assign a Name to a cell, or to a Range of cells. This name is reffered to as a Defined Name.
A Defined Name will give more flexibility than before, you can refer to it in your formulas, or chart series.
Also, the name can be located anywhere in your workbook, you don’t need to use cell or range references.