'%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)
How to Fix Shift and Arrow Keys Selecting Only Two Cells in Excel
Question details
The user is unable to continuously select multiple adjacent cells using the Shift and Arrow keys, as the selection process unexpectedly stops after highlighting just two cells.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Attempting to select a range of multiple adjacent cells in an Excel worksheet using standard keyboard shortcuts.
- Observed behavior
- When holding the Shift key and pressing the Right Arrow key, Excel highlights a maximum of two cells and will not select further, despite Scroll Lock being disabled and the keys functioning normally in Excel for the web.
Before proceeding with software repairs, test your keyboard in another application like Notepad to rule out hardware issues, and double-check that the Scroll Lock indicator on your keyboard or Excel status bar is turned off.
Repair the Microsoft Office Installation
Since the issue does not occur in Excel for the web, the local Microsoft Office installation may be corrupted. Running the built-in repair tool often resolves unexplained shortcut and UI glitches.
Windows provides built-in tools to repair Microsoft Office applications without deleting your personal files or spreadsheets. This process restores the default functionalities of Excel, fixing bugs related to cell selection and keyboard shortcuts.
Press the Windows key + I on your keyboard to open Windows Settings, or search for 'Control Panel' in the Windows search bar.
In Settings, go to 'Apps' and then 'Installed apps'. If you are using the Control Panel, go to 'Programs' and select 'Programs and Features'.
Scroll down the list of installed programs until you find 'Microsoft 365', 'Microsoft Office', or your specific version of Office. Click the three dots next to it (or right-click) and select 'Change' or 'Modify'.
A dialog box will appear. Select the 'Quick Repair' option and click 'Repair'. Follow the on-screen prompts to allow the process to finish.
Once the Quick Repair is complete, restart your computer. Open Excel and test the Shift + Arrow keys to see if you can now select more than two cells.
Try WPS Office for a Bug-Free Spreadsheet Experience
If repairing Microsoft Excel doesn't resolve your keyboard shortcut glitches or you are tired of dealing with sudden software errors, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative for managing all your spreadsheets seamlessly.
- 1. Download WPS Office: Visit the official WPS website and click the free download button to get the installer.
- 2. Install the Software: Run the downloaded file and follow the simple on-screen instructions to install WPS Office on your computer.
- 3. Open Your Spreadsheets: Right-click your existing .xlsx files, choose 'Open with', and select WPS Spreadsheets to continue working without interruption.
Frequently Asked Questions
Why is Excel not selecting multiple cells when I use Shift and Arrow keys?
This issue is commonly caused by Scroll Lock being turned on, Excel being stuck in 'Extend Selection' mode (triggered by the F8 key), hardware issues with the keyboard, or a corrupted Microsoft Office installation.
Does the F8 key replace the Shift + Arrow key function in Excel?
Yes. Pressing the F8 key activates 'Extend Selection' mode, which is indicated in the bottom status bar. Once activated, you can simply use the Arrow keys without holding Shift to select multiple cells. Press F8 again to turn this mode off.
How do I select multiple non-adjacent cells in an Excel spreadsheet?
To select cells that are not next to each other, hold down the Ctrl key while clicking on the individual cells or ranges you want to highlight.
Can a faulty keyboard cause the Shift key to fail in Excel?
Absolutely. Hardware issues, such as a sticky or malfunctioning Shift key, can prevent continuous cell selection. Testing the keyboard on another computer or in a different application like Notepad can help rule out hardware failure.
