Fix Excel F8 Extend Selection Stopping After Two Cells
Question details
The user needs to determine why Excel's F8 Extend Selection mode stops after selecting two cells.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user presses F8 and uses the arrow keys to extend a cell selection.
- Observed behavior
- Extend Selection mode stops after only two cells are selected.
Note whether the problem occurs in one workbook or also in a new blank workbook. Do not enable macros in a workbook you do not trust.
Test the workbook without running automatic macros
Use this test to check whether a workbook's startup macro is interfering with F8.
Close the affected workbook. In Excel, choose File > Open, select the workbook, and hold Shift while opening it to bypass automatic startup macros.
Select a cell, press F8, and use the arrow keys to extend the selection beyond two cells. Press F8 again to turn off Extend Selection.
If selection works normally, open Developer > Visual Basic and inspect the workbook's startup and selection-related code for actions that change the selection or keyboard behavior.

Test Excel in Safe Mode and isolate add-ins
Use this method if bypassing workbook macros does not resolve the issue, especially when it also occurs in other workbooks.
Work with Excel Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open existing Excel files in WPS Spreadsheets for an easy transition, though it does not repair Excel's F8 behavior.

Frequently Asked Questions
How do I use F8 to extend a selection in Excel?
Select a starting cell, press F8, and use the arrow keys to extend the selection. Press F8 again to turn Extend Selection off.
How can I tell whether a workbook macro is causing the problem?
Close the workbook and hold Shift while reopening it through File > Open. If F8 works normally afterward, inspect the workbook's startup and selection-related code in Developer > Visual Basic.
How do I start Excel in Safe Mode?
On Windows, close Excel, hold Ctrl while opening it, and confirm the Safe Mode prompt. You can also press Windows+R, enter excel /safe, and select OK.
Where can I disable Excel and COM add-ins?
Go to File > Options > Add-ins. Select Excel Add-ins or COM Add-ins in the Manage list, choose Go, and clear add-ins one at a time while retesting F8.




