Fix Excel Runtime Error 1004 When Using Ctrl+X to Cut Cells
Question details
The user needs to resolve Runtime Error 1004 when cutting, deleting, or moving cells in Microsoft Excel.
- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- Windows 10; Ctrl+X reportedly works on the user's Mac
- Scenario
- The user uses Ctrl+X while working with cells, rows, or columns and also encounters the error when deleting or moving cells.
- Observed behavior
- Excel displays Runtime Error 1004 on Windows 10. Updating and reinstalling Microsoft 365 have not resolved the issue.
Identify whether you want to cut and move cells, clear their contents, or delete entire rows or columns; these are different operations. Note whether the error affects one workbook or all workbooks, and whether it appears only with Ctrl+X or also with Home > Cut.
Use the correct command and test a simple cell range
Confirm that Ctrl+X is appropriate for the task and determine whether the error is caused by the selected range or workbook.
Ctrl+X cuts a selection for moving it elsewhere; it does not delete rows or columns. Runtime Error 1004 can also occur when Excel or a macro cannot perform an operation on the selected range.
To move cells, select one continuous range and choose Home > Cut, then select the destination and paste. To clear values while keeping the cells, press Delete. To remove entire rows or columns, use Home > Delete > Delete Sheet Rows or Delete Sheet Columns.
In Excel for Windows, select the affected rows or columns. Press Alt, H, D, R in sequence to delete rows, or Alt, H, D, C in sequence to delete columns.
Choose File > New > Blank workbook, enter a value in A1, and try cutting it to B1. Compare Ctrl+X with Home > Cut, then test deleting a row. If the blank workbook works, investigate the original workbook rather than reinstalling Office again.
In the affected workbook, select a small, continuous range without merged cells and retry Home > Cut. Check Review > Unprotect Sheet if the sheet is protected; only remove protection if you are authorized and have the required password.
Start Excel in Safe Mode and isolate conflicting add-ins
Use this when the error affects multiple workbooks or when a keyboard shortcut may be intercepted by an add-in.
Check workbook macros, shortcut remapping, and Office installation
Use this when the error persists, especially if updating or reinstalling Microsoft 365 has already failed.
Use WPS Spreadsheet for everyday cell editing
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel files. Open existing workbooks to continue everyday editing with minimal migration effort; WPS does not repair Excel's Runtime Error 1004 or guarantee compatibility with VBA macros and Excel add-ins.
Frequently Asked Questions
Does Ctrl+X delete rows or columns in Excel?
No. Ctrl+X cuts the selection so you can paste it elsewhere. To remove rows or columns, use Home > Delete > Delete Sheet Rows or Delete Sheet Columns. Pressing Delete alone clears cell contents without removing the cells.
How do I open Excel in Safe Mode on Windows 10?
Close Excel, press Windows+R, type excel /safe, and press Enter. Test Ctrl+X in a blank workbook. If it works there, investigate add-ins through File > Options > Add-ins and other startup customizations.
What should I check if Home > Cut works but Ctrl+X fails?
Check Excel add-ins, VBA shortcut assignments such as Application.OnKey, and external keyboard-remapping or clipboard utilities. Disable or exit these components one at a time and retry Ctrl+X to identify the conflict.
Why does the error affect only one workbook?
The workbook may contain a failing macro, protected cells, merged ranges, or a selection that cannot be moved as requested. Compare it with File > New > Blank workbook, then test a small continuous range and review the affected workbook's macros and sheet protection.
Will WPS Office fix Excel Runtime Error 1004?
No. WPS Office does not repair Microsoft Excel or its VBA and add-in environment. WPS Spreadsheet can provide an alternative for editing compatible .xlsx and .xls files, but macro-dependent workbooks require separate compatibility checks.
