Document Editing Problems

Fix Excel Rows or Columns Cannot Be Moved by Shift-Dragging

Ayan Masood Sep 27, 2026 871 views

Question details

The user is unable to move rows or columns in Excel using the standard shift-drag method.

How to Fix Excel Rows or Columns Not Moving by Shift-Dragging

Product: Microsoft Excel
Device & OS: not provided
Scenario: Trying to rearrange data by selecting rows or columns and shift-dragging them to a new location in the worksheet.
Observed behavior: When releasing the mouse button, the selected row or column fails to move and remains in its original position.

Before you start

Ensure that your worksheet is not protected and that you are not actively editing a cell's contents (indicated by a blinking text cursor inside the cell).

Solution 1Recommended

Use the Four-Headed Arrow Cursor Correctly

Ensure you are interacting with the correct part of the selection border to trigger the drag-and-drop function.

Excel requires precise cursor positioning to initiate a move command. If your cursor is positioned incorrectly, Excel may just highlight adjacent cells or trigger the auto-fill feature.

Select the entire row or column

Click the row number on the left side or the column letter at the top to highlight the entire row or column.

Position your cursor

Hover your mouse pointer directly over the green border of the selected area until the cursor changes from a thick white cross into a four-headed arrow.

Execute the shift-drag

Press and hold the 'Shift' key on your keyboard. Click and hold the left mouse button, then drag the selection to the desired location. A thick green indicator line will show where the data will be inserted.

Release the keys in order

Release the left mouse button first to drop the data, and then release the 'Shift' key.

Use the Four-Headed Arrow Cursor Correctly

Cursor Positioning: If you see a black crosshair instead of a four-headed arrow, you are hovering over the bottom-right corner (Fill Handle). This will not move the row or column, but will instead attempt to copy the data.

Solution 2

Enable Drag-and-Drop in Excel Options

Verify that the drag-and-drop feature hasn't been accidentally disabled in your Excel settings.

Solution 3

Check for Conflicting Excel Add-ins

Third-party add-ins can sometimes interfere with native Excel mouse behaviors.

Free Microsoft Office alternative

Edit and Reorganize Spreadsheets Seamlessly in WPS Office

If Microsoft Excel's drag-and-drop features are consistently freezing or failing, WPS Office provides a lightweight, highly compatible alternative. You can easily manage rows, columns, and heavy datasets without frustrating UI bugs.

1. Download and install: Download WPS Office for free from the official website and complete the quick installation.
2. Open your file: Launch WPS Spreadsheet and open your existing Excel file.
3. Rearrange seamlessly: Select any row or column and effortlessly shift-drag it to your preferred location without lag or bugs.

100% free to use for everyday spreadsheet creation and editing.Seamlessly compatible with all Microsoft Excel formats (.xls, .xlsx, .csv).Intuitive drag-and-drop functionality that works reliably across all devices.Lightweight software with fast loading speeds and robust performance.

microsoft office alternative - wps office

Frequently Asked Questions

Why does dragging a column replace the existing data instead of moving it?

If you simply click and drag a column without holding the 'Shift' key, Excel attempts to overwrite the destination cells. Holding the 'Shift' key signals Excel to insert the selection between existing columns instead of replacing them.

Does 'Freeze Panes' affect the ability to drag rows or columns?

Yes, in some Excel versions, having 'Freeze Panes' enabled can interfere with drag-and-drop capabilities, especially when trying to move data across the frozen boundaries. Try going to View > Window > Unfreeze Panes to restore functionality.

How do I move a row if my mouse drag is not working at all?

If shift-dragging completely fails, you can use the cut-and-insert method. Select the row, press Ctrl+X to cut it, right-click the destination row header, and choose 'Insert Cut Cells'.

What should I do if my cursor doesn't change to a four-headed arrow?

Ensure you are hovering over the very edge (the green outline) of the highlighted selection. If the cursor still doesn't change, verify that 'Enable fill handle and cell drag-and-drop' is turned on in your Excel Advanced Options.

Document & File Issues