Instead of manually typing pieces of a cell reference, use this quick mouse trick to extend the reference when modifying a formula.
When we need to edit an Excel formula, usually we will press [F2] and modify. Or we can also click inside the formula bar and then use the keyboard to modify cell references. For instance, as the Excel worksheet below, to include values for Canada, we’d press [F2] or click the formula bar and then highlight the 6 in the B6 reference and type 7.
When we need to edit an Excel formula, usually we will press [F2] and modify. Or we can also click inside the formula bar and then use the keyboard to modify cell references. For instance, as the Excel worksheet below, to include values for Canada, we’d press [F2] or click the formula bar and then highlight the 6 in the B6 reference and type 7.
However, you might have noticed that Excel outlines the referenced range when editing Excel formulas. Anyway, we can extend that range to update the formula’s reference. First, hover the mouse over one of the corner handles until Excel displays the double-arrow pointer. Then, click the handle and extend it to include the appropriate cell(s). This automatically adjusts the respective reference. At last, enter the modified formula.
In addition, we can also move the reference instead of extending it by hovering over a border instead of a corner handle. Excel will display the four-arrow pointer, which we can then use to move the border. This is much easier than highlight characters one at a time.