Use the F4 key right after you type the cell address you wish to anchor. In this example you would key in =c1 then press the F4 key. Once you have the appropriate anchor set, then simply continue typing your formula as usual.