Absolute Cell Reference

J

Joshua K Briley

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?
 
B

Bob Phillips

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)
 
J

Joshua K Briley

Thanks Bob...
--
Somecallmejosh


Bob Phillips said:
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)
Click to expand...
 
P

pinmaster

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

Ex. =SUM(A1:A10)*price

HTH
J
 
J

Joshua K Briley

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