Clear Copy Mode and the Clipboard in Excel 2016
Question details
The user wants to clear Excel's copied-cell state so the standard Insert dialog opens instead of the Insert Paste dialog.

- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- After copying cells and editing a cell with F2 and Enter, the user presses Ctrl+Shift+Plus to insert cells.
- Observed behavior
- The copied-cell border may remain active, and Excel opens the Insert Paste dialog rather than the standard Insert dialog.
Check whether a moving border still surrounds the copied cells. Distinguish canceling that copy mode from clearing items stored in the Office Clipboard.
Cancel copy mode and clear the Office Clipboard
Use Esc to cancel an active copy operation, and clear the Office Clipboard pane if you also want to remove its stored items.
In the worksheet, press Esc and check whether the moving border around the copied cells disappears.
On the Home tab, click the small dialog box launcher in the Clipboard group.
In the Clipboard pane, click Clear All to remove the items listed in the Office Clipboard.
Return to the worksheet, select the target cells, and press Ctrl+Shift+Plus to check which Insert dialog appears.

Insert entire worksheet rows or columns from the ribbon
Use the ribbon when you need to insert whole rows or columns rather than open the cell Insert dialog.
Work with spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Its Microsoft Office format support helps you move existing files into WPS, though it does not change Excel 2016's clipboard behavior.

Frequently Asked Questions
How do I remove the moving border around copied cells in Excel 2016?
Press Esc in the worksheet to cancel the active copy operation. If the reported Insert dialog behavior continues, Esc may not resolve that specific issue.
Where is Clear All in the Excel 2016 Clipboard?
Go to Home and click the small dialog box launcher in the Clipboard group. In the pane that opens, click Clear All to remove its listed items.
Does clearing the Office Clipboard restore Excel 2010 behavior?
No. Clearing the Office Clipboard removes its stored items, but it does not provide a supported way to make Excel 2016 handle copy mode exactly like Excel 2010.
Can I insert a row without using Ctrl+Shift+Plus?
Select a row number, then go to Home > Insert in the Cells group and choose Insert Sheet Rows.




