'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel Arrow Keys Returning to Formula Cell Instead of Referenced Cell
Question details
The user is experiencing an issue where, after reinstalling Excel, pressing Enter while using arrow keys to select formula references returns the selection to the formula cell rather than the last referenced cell.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Entering formulas using arrow-key navigation
- Observed behavior
- Pressing Enter returns the cursor or selection to the original formula cell instead of preserving the last referenced cell.
Ensure that Scroll Lock is turned off on your keyboard, as an active Scroll Lock can significantly alter default arrow key behavior during cell navigation.
Test in a New Workbook and Disable Add-ins
Isolate the issue by checking if it is specific to the current workbook or caused by third-party Excel add-ins.
Third-party add-ins or corrupted workbook settings can sometimes hijack standard keyboard inputs and change how formula references behave.
Open Excel and create a new, blank workbook to see if the formula navigation issue persists in a fresh environment.
Close Excel, then hold the Ctrl key while clicking the Excel shortcut to launch the application in Safe Mode, which temporarily disables all add-ins.
If the issue stops in Safe Mode, navigate to File > Options > Add-ins. Select 'COM Add-ins' from the Manage dropdown, click 'Go', and uncheck items one by one to identify the culprit.
Verify Worksheet Protection and Update Excel
Check that the worksheet isn't locked and that you have the latest software updates installed, which may patch navigation bugs.
Repair Microsoft 365 Installation
Use the built-in repair tool to fix corrupted Office files that might be causing irregular formula navigation behavior.
Experience Smooth Formula Entry with WPS Office
If Microsoft Excel's formula navigation behavior is disrupting your workflow or lacking configurable options, try WPS Office. It provides a lightweight, highly compatible spreadsheet environment where formula entry and arrow-key cell selection work exactly as you expect.
- 1. Install WPS Office: Download and install WPS Office for free from the official WPS website.
- 2. Open your Workbook: Launch WPS Spreadsheets and seamlessly open your existing Microsoft Excel files.
- 3. Edit Formulas Smoothly: Type your formula and use the arrow keys to select referenced cells with standard, predictable navigation behavior.
Frequently Asked Questions
Why do my arrow keys move the whole spreadsheet instead of moving between cells?
Your Scroll Lock key is likely enabled. Press the 'Scroll Lock' (ScrLk) key on your keyboard to turn this off. You can also right-click the status bar at the bottom of the Excel window to check if the Scroll Lock indicator is active.
Is there a specific setting in Excel to change formula return behavior?
No, standard Excel settings do not have a built-in, configurable option to change where the cursor lands specifically after pressing Enter during a formula selection. It generally defaults to returning to the formula cell.
Why can't I select cells with arrow keys while writing a formula?
You may be trapped in 'Edit' mode rather than 'Enter' or 'Point' mode. Press the F2 key on your keyboard to toggle between Edit mode (which moves the cursor within the text of the formula) and Enter/Point mode (which allows you to select surrounding cells).
