Fix Strange Row and Column Selection in Excel
Question details
Resolve unusual row and column highlighting, a dotted border, and a small square appearing during selection in Excel.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user is selecting cells in an Excel worksheet and wants normal highlighting and selection behavior.
- Observed behavior
- Only column A appears highlighted, a dotted border surrounds the sheet, and a small square appears during selection.
Open the affected worksheet and check whether the dotted border moves around a copied range or marks a page boundary. Note whether the small square appears at the corner of the selected cell or range.
Exit Copy Mode and Restore the Normal Worksheet View
Use these checks to rule out an active copy operation, a worksheet view, or a selection handle.
Press Esc, then click a single cell outside column A. If the border was caused by an active copy operation, Esc should dismiss it.
Go to View > Normal to leave Page Break Preview or another worksheet view, then test the selection again.
Go to View > Freeze Panes and choose Unfreeze Panes if that option is available and frozen rows or columns are not needed.
Click a cell and move the pointer away from the small square at the lower-right corner of the selection. That square is normally the fill handle; dragging it copies or fills cells.

Restart Excel and Check Add-ins in Safe Mode
Use this approach if the selection or display issue continues after checking the worksheet view.
Work With Excel Spreadsheets in WPS Office
WPS Office is a free, lightweight, easy-to-use alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheet for a straightforward transition, though it does not repair Excel itself.

Frequently Asked Questions
Why is there a moving dotted border around my selection?
Excel displays a moving border around a copied range. Press Esc to cancel the active copy operation and remove that border.
What is the small square at the corner of a selected cell?
It is usually the fill handle. Drag it to copy cell contents or extend a series; click elsewhere if you only want to select another cell.
How do I leave Page Break Preview in Excel?
Open the View tab and select Normal. Some dotted page-break lines may still appear after you switch views.
How can I tell whether an add-in is causing the issue?
On Windows, press Windows+R, enter excel /safe, and open the workbook. If the issue disappears, restart Excel normally and check add-ins under File > Options > Add-ins.




