Absolute Cell Reference
 

When creating a formula in a cell, and using another cell as part of that
formula, is there a way to select a cell to automatically place the $ in
front of the column and row identifiers... looking for a way not to have to
type in the "$" every time...

Example
I enter the "=" sign in a cell... I want the results of another cell to be
part of the formula in the original cell I typed the "=" sign...

=$b$11 .... Am I forced to type in the "$" signs EVERY time?
--
Somecallmejosh

Absolute Cell Reference
 

By the way, I am using Office 2K...
--
Somecallmejosh


"Joshua K Briley" wrote:

When creating a formula in a cell, and using another cell as part of that
formula, is there a way to select a cell to automatically place the $ in
front of the column and row identifiers... looking for a way not to have to
type in the "$" every time...

Example
I enter the "=" sign in a cell... I want the results of another cell to be
part of the formula in the original cell I typed the "=" sign...

=$b$11 .... Am I forced to type in the "$" signs EVERY time?
--
Somecallmejosh

Absolute Cell Reference
 

In reality yes. You can toggle it after entering it using F4, but that is
not much different in practice.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Joshua K Briley" wrote in message
...
By the way, I am using Office 2K...
--
Somecallmejosh


"Joshua K Briley" wrote:

When creating a formula in a cell, and using another cell as part of
that
formula, is there a way to select a cell to automatically place the $ in
front of the column and row identifiers... looking for a way not to have
to
type in the "$" every time...

Example
I enter the "=" sign in a cell... I want the results of another cell to
be
part of the formula in the original cell I typed the "=" sign...

=$b$11 .... Am I forced to type in the "$" signs EVERY time?
--
Somecallmejosh

Absolute Cell Reference
 

Thanks Bob...
--
Somecallmejosh


"Bob Phillips" wrote:

In reality yes. You can toggle it after entering it using F4, but that is
not much different in practice.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Joshua K Briley" wrote in message
...
By the way, I am using Office 2K...
--
Somecallmejosh


"Joshua K Briley" wrote:

When creating a formula in a cell, and using another cell as part of
that
formula, is there a way to select a cell to automatically place the $ in
front of the column and row identifiers... looking for a way not to have
to
type in the "$" every time...

Example
I enter the "=" sign in a cell... I want the results of another cell to
be
part of the formula in the original cell I typed the "=" sign...

=$b$11 .... Am I forced to type in the "$" signs EVERY time?
--
Somecallmejosh

Absolute Cell Reference
 

If there are certain cells that you use a lot in your formulas it might
be easier to DEFINE them (give each a name), say A1 refers to the price
of a product, select A1 and type a name in the name box (left of the
formula bar) say "price" then use that name in your formula:

Ex. =SUM(A1:A10)*price

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=496190

Absolute Cell Reference
 

The cells are not static.... the ones I have to copy are peppered throughout
the worksheet. Thanks for your response.
--
Somecallmejosh


"pinmaster" wrote:


If there are certain cells that you use a lot in your formulas it might
be easier to DEFINE them (give each a name), say A1 refers to the price
of a product, select A1 and type a name in the name box (left of the
formula bar) say "price" then use that name in your formula:

Ex. =SUM(A1:A10)*price

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=496190