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