Fix WPS Spreadsheets Arrow Keys Not Selecting Cells in Formulas
Question details
User needs arrow keys to select cell references while entering a formula in an Excel-compatible spreadsheet instead of moving the text cursor.

- Product
- WPS Spreadsheets (Excel-compatible)
- Device & OS
- not provided
- Scenario
- User is typing a formula such as =SUM( and wants to use arrow keys to select the target cell or range for the formula.
- Observed behavior
- Arrow keys move the cursor inside the formula instead of selecting cell references.
Make sure you are entering a formula in an Excel-compatible spreadsheet such as WPS Spreadsheets, not in a plain text cell. Check the lower-left status bar to see whether the current mode is Ready, Enter, Edit, or Point before changing keyboard behavior.
Use F2 to Switch to Formula Point and Edit Mode in WPS Spreadsheets
Use this solution when arrow keys move the text cursor inside a formula instead of selecting cell references.
WPS Spreadsheets uses the same formula entry modes as Microsoft Excel. The F2 key toggles between editing the formula text and selecting cell references, which usually resolves the arrow-key issue immediately.
Open WPS Spreadsheets, click the cell where you want the formula, and type =SUM( or another function.
Press F2 once. In WPS Spreadsheets this toggles between editing the formula text and pointing to cell references. Check the status bar for Enter, Edit, or Point mode.
Press the arrow keys to move the active selection border to the target cell or range instead of moving the text cursor.
Press Enter to accept the formula and return to Ready mode.
Turn Off Scroll Lock and Check Laptop Keyboard Settings
Use this solution when F2 alone does not help and the arrow keys still behave as navigation keys.
Disable Suspicious Add-ins in WPS Spreadsheets
Use this solution when the arrow-key issue appears only in certain workbooks or after installing an add-in.
Use WPS Spreadsheets to Fix Arrow-Key Cell Selection in Formulas
WPS Spreadsheets offers an Excel-compatible formula editing environment. You can switch between edit and point modes with F2, so arrow keys select cell references exactly as expected, without losing .xlsx compatibility.
- 1. Open WPS Spreadsheets: Launch WPS Office and open your workbook in WPS Spreadsheets.
- 2. Enter the formula: Select a cell and type =SUM( or the required function.
- 3. Press F2: Press F2 to switch between formula edit and point selection modes until arrow keys select cells.
- 4. Select the range and finish: Use arrow keys to highlight the range, then press Enter to complete the formula.
- 5. Save in Excel format: Press Ctrl+S and choose .xlsx if you need Microsoft Excel compatibility.

Frequently Asked Questions
Why do my arrow keys move the cursor instead of selecting cells in a formula?
You are likely in Edit mode. Press F2 in WPS Spreadsheets to cycle formula modes until the status bar shows Point. Then arrow keys select cell references instead of moving the text cursor.
Does F2 work the same in WPS Spreadsheets as in Microsoft Excel?
Yes. WPS Spreadsheets preserves the Excel-compatible F2 behavior for entering and leaving formula edit mode, so Excel users can follow the same steps.
What should I check if F2 does not fix the arrow key problem?
Check Scroll Lock, function-key lock on laptops, keyboard layout, and disable add-ins by going to Menu > Options > Add-ins in WPS Spreadsheets.
Can I use the mouse instead of arrow keys to select formula ranges?
Yes. While entering a formula, drag with the mouse across the range, or click the first cell, hold Shift, and click the last cell.
Will this fix affect my existing Excel formulas?
No. Changing input mode only affects how you enter or edit the current formula. Existing formulas and data remain unchanged.




