LinkBack URL
About LinkBacks
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
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
click in it and then click on the F4 key.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
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
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks