VBA & Macro Problems

Fix Excel F8 Extend Selection Stopping After Two Cells

Aamir Naveed AkramAamir Naveed Akram Nov 22, 2026 868 views

Question details

The user needs to determine why Excel's F8 Extend Selection mode stops after selecting two cells.

Fix Excel F8 Extend Selection Stopping After 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.
Before you start

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.

Solution 1Recommended

Test the workbook without running automatic macros

Use this test to check whether a workbook's startup macro is interfering with F8.

1
Open the workbook with Shift

Close the affected workbook. In Excel, choose File > Open, select the workbook, and hold Shift while opening it to bypass automatic startup macros.

2
Test Extend Selection

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.

3
Review the macro code

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 the workbook without running automatic macros
Macro precautions: Holding Shift is a troubleshooting step, not a substitute for Excel's macro security settings. Review code only in workbooks you trust.
Free Microsoft Office alternative

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.

Select and edit spreadsheet cells in a familiar interfaceCompatible with Microsoft Excel formats including XLS and XLSXFree and lightweight for everyday spreadsheet workOpen existing spreadsheets without starting from scratch
microsoft office alternative - wps office

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.