You could use ctrl+H to find & replace the cell reference with the
mixed/absolute reference, or when you go into the formula to edit the
reference just hit your F4 key to toggle between absolute, mixed, and
relative referencing.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"hgood" wrote:

I want to create formulas in excel and i need the formulas to reference
certain cells multiple times. Is there a way to have the $ added to my
formulas without having to type it? Thanks.