Define a Name

  • Thread starter Thread starter ASPENCO
  • Start date Start date
A

ASPENCO

I was looking at the sample chapter of Joseph Rubin's new boo
"Financial Statements.xls" and the first thing he has you do is defin
a cell named CompanyName so that when the company name changes you ca
easily change it in all cells. He provides the following instruction
which don't seem to work and I was wondering what I was doing wrong.
Thanks.

1. In cell C2 type the company's name (elg. ABC Corp.).
2. Define that cell with the name CompanyName.
3. In cell C2 type the formula "=CompanyName".

What am I missing? Thanks again for your help
 
Step 2: Insert>Name>Define. Probably "ABC Corp" is already in the box,
otherwise enter it and hit OK. Note that C2 still has to be selected when
you start this sequence.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
ASPENCO,
Another quick way to define a name for a cell is in the left-hand corner just above the spreadsheet. With cell C2 selected, you should see C2 in this corner. Simply click on the C2, type in the name, and hit enter. You can do this for ranges as well.

Good Luck,
Mark Graesser
(e-mail address removed)

----- ASPENCO > wrote: -----

I was looking at the sample chapter of Joseph Rubin's new book
"Financial Statements.xls" and the first thing he has you do is define
a cell named CompanyName so that when the company name changes you can
easily change it in all cells. He provides the following instructions
which don't seem to work and I was wondering what I was doing wrong.
Thanks.

1. In cell C2 type the company's name (elg. ABC Corp.).
2. Define that cell with the name CompanyName.
3. In cell C2 type the formula "=CompanyName".

What am I missing? Thanks again for your help.
 
Hi Aspenco!

And another that doesn't require a cell in the workbook.

Insert > Name > Define
Type in (e.g.) Norm
In the refers to box type
="Norman Harker"
OK

But it's not so much a defined name as a defined formula. Although to
be strictly correct, defined names are defined formulas.

It's a less user friendly way than assigning names to cells.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top