how can i add $ to formulas with a click of a button to ?
 

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.

how can i add $ to formulas with a click of a button to ?
 

A bit more detail and example(s)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"hgood" wrote in message
...
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.

how can i add $ to formulas with a click of a button to ?
 

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.