View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Joshua K Briley
 
Posts: n/a
Default 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