For other reference cells please repeat the above step. In the left pane click Advanced. The dialog box takes care of the syntax such as placing comma separators between arguments and surrounding text entries in quotation marks.
Alternatively you can display the Formula Bar using Excel Options.
Click on the reference cell you want to always use in the formula and then press the F4 key. At the end of the formula add a plus sign. As you type the data notice the data also appear in the Formula Bar. Click the Kutools Work Area it will automatically maximize the Excel window by hiding the Status Bar Formula Bar and Ribbon.