View Single Post
Old 05-11-2009, 03:41 PM
BG5150's Avatar
BG5150 BG5150 is offline
Join Date: Jan 2009
Favorite beer: the one you're buying me
Posts: 23,008

Is there any shortcut to make a cell reference an anchor cell?

For example, I have 500 in A1.

In my formula, I have "+A1 * C1" I'd like the A1 to read $A$1. Is there a way, when I click A1 to add it to my formula to make it that way? It becomes a pain to create my formula, hit F2, edit it and then copy it.
Reply With Quote
Page generated in 0.08606 seconds with 9 queries