Formula Errors

Enter an Excel Formula Using Keyboard Arrow Keys

Aamir Naveed AkramAamir Naveed Akram Nov 22, 2026 868 views

Question details

The user wants to select cell references with the keyboard while entering an Excel formula.

Enter an Excel Formula Using Keyboard Arrow Keys
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.
Before you start

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.

Solution 1Recommended

Select Formula References with the Arrow Keys in Excel

Use this method to build a formula without clicking the referenced cells.

1
Start the formula

Select cell C3 and type = to begin entering a formula.

2
Select the first reference

Press the Down Arrow key nine times to select C12. The formula should now show =C12.

3
Add the operator and second reference

Type /, then press the Up Arrow key twice to select C10. The formula should now show =C12/C10.

4
Complete the formula

Press Enter to place the formula in C3 and calculate the result.

Select Formula References with the Arrow Keys in Excel
Arrow keys move through the formula text: If you are editing an existing formula and the arrow keys move the text cursor instead of selecting cells, press F2 to switch from Edit mode to Enter mode, then try selecting a reference again.
Work with formulas in WPS Spreadsheets

Build Formulas with Arrow Keys in WPS Spreadsheets

Use WPS Spreadsheets to enter a formula and select its cell references with your keyboard.

  1. 1. Open the worksheet: Open your workbook in WPS Spreadsheets and select cell C3.
  2. 2. Select the first cell: Type =, then press the Down Arrow key nine times to select C12.
  3. 3. Add the second reference: Type / and press the Up Arrow key twice to select C10.
  4. 4. Enter the formula: Confirm that the formula reads =C12/C10, then press Enter.
Select formula references without using a mouseOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceGet started with the free WPS Office suite
microsoft office alternative - wps office

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.