To activate, after typing in a command on the command line just press the F4 key and up will pop all the parameters for the command, you can usually use the F4 key again in each of the parameter fields to display a list of values available for those parameters.

Once you have typed in the Cell address like C4 you can move back into the cell address and then use the F4 key to toggle the cell reference from Relative to Absolute to a Mixed References.

Monthly Sales Salesperson By Quantity Brown 1 Adams 3 Brown 5 Caldwell 2 Adams 3 Caldwell 5 Brown 9 Results: Excel changes the data to display as follows: Monthly Sales Salesperson By Quantity Adams 3 Adams 3 Brown 1 Brown 5 Brown 9 Caldwell 2 Caldwell 5 The F4 Key (E) Description: When you create a formula in Excel, the formula can use relative cell references, which refer to cells relative to the position of the formula, or absolute references, which refer to cells in a specific location.