Formulas

I may be missing something, but I cannot seem to enter a formula with a cell reference using the Excel method. Must the cell reference be manually typed every time? If so, please change. If not, please explain how.
esaeo1