Enter an Excel Formula Using Keyboard Arrow Keys
Question details
The user wants to select cell references with the keyboard while entering an Excel formula.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Enter a formula using arrow keys instead of selecting referenced cells with a mouse.
- Observed behavior
- The user wants to move between cells while building the formula and press Enter only when it is complete.
Open the worksheet and choose an empty cell for the formula. Identify the cells you want to reference and the operator you want to use.
Select Formula References with the Arrow Keys in Excel
Use this method to build a formula without clicking the referenced cells.
Select cell C3 and type = to begin entering a formula.
Press the Down Arrow key nine times to select C12. The formula should now show =C12.
Type /, then press the Up Arrow key twice to select C10. The formula should now show =C12/C10.
Press Enter to place the formula in C3 and calculate the result.

Build Formulas with Arrow Keys in WPS Spreadsheets
Use WPS Spreadsheets to enter a formula and select its cell references with your keyboard.
- 1. Open the worksheet: Open your workbook in WPS Spreadsheets and select cell C3.
- 2. Select the first cell: Type =, then press the Down Arrow key nine times to select C12.
- 3. Add the second reference: Type / and press the Up Arrow key twice to select C10.
- 4. Enter the formula: Confirm that the formula reads =C12/C10, then press Enter.

Frequently Asked Questions
Why do the arrow keys move through my formula instead of selecting cells?
You may be in Edit mode. In Excel, press F2 to switch to Enter mode, then use an arrow key where you want to insert a cell reference.
Can I enter a formula without using the mouse?
Yes. Select the formula cell with the keyboard, type =, use the arrow keys to select each referenced cell, and type an operator between references. Press Enter when the formula is complete.
Why does my division formula show a #DIV/0! error?
The denominator is zero or empty. For =C12/C10, check the value in C10 and enter a nonzero number if appropriate.
Should I use Tab to select the next cell reference?
Use the arrow keys to select a reference while building the formula. Tab can finish an entry and move to another cell rather than add the reference you need.




