
|
|
Advantages to using Named ranges (or cells):
|
|||||||
For example:
|
||||||||
To name
cell(s) when the name(s) is/are next to it (one cell to the left, right, above or below)
|
||||||||
To Name
ranges like a table or when the name is not
already on the sheet
|
||||||||
| If you name a cell/range before you enter it in a formula, Excel will
automatically use the name when you point to the cell.
If you name the cell/range after using it in formulas, you
need to Apply the name to the cell where it is
used.
So if you drag down a formula and the value that appears is really weird, this is probably because one of the cell references should have been an absolute value. To correct this: Figure out which number should have not changed when you dragged the formula and assign that number a name. Use Create if there is a name adjacent to the referred to cell, use Define if not. Select the cell that you dragged down, the one that had a good value showing. Do a Insert Menu, Name, Apply. Now you should see the name in the formula and be able to drag it to adjacent cells. |
||||||||
| More Help in the Tutorials |
|
This page was created by Professor
Maureen Greenbaum and was last updated on
03/19/08
.
Disclaimer: Information on this site
represents the thoughts and opinions expressed by the author and not that of
Union County College. The author takes full
responsibility for the information presented. By using the information
contained herein, the user willingly assumes all risks in connection with
such use. Neither the author nor Union County College shall be held liable
or responsible for content, errors, and/or omissions in information herein
or information contained on any Web Page to which it is linked.
Furthermore, neither the author nor Union County College shall be liable for
any special, consequential, or exemplary damages resulting, in whole or in
part, from any user's use of, or reliance on, this material or material set
forth on any Web Page to which it is linked. |