Remove dollar sign in a formula

[jolenec]

Hi Guys,

Is there a quick way to ask Excel to stop referring to one cell?
For example, the formula is this: =$A$2*B1, is there a quick way to change to =A2*B1?

Thanks!
Jolene

[Sam Capricci]

click in it and then click on the F4 key.

[jolenec]

I got a Mac, the shortcut for that is ⌘+T, but it won't work on mine, pro just b/c its mac... Thanks anyway

[Sam Capricci]

I know your frustration, i'm working from home on a mac now. See if you can find it on this link…
http://office.microsoft.com/en-us/ma...102927337.aspx
I know there is one but I cannot remember what it is.

[Sam Capricci]

Found it at that link and you're right, it is that symbol and T. If it isn't working on yours I'm not sure why, it is functioning on mine. Good luck though.