Office Settings & Configuration

Clear Copy Mode and the Clipboard in Excel 2016

Kushani NimanthikaKushani Nimanthika Nov 22, 2026 868 views

Question details

The user wants to clear Excel's copied-cell state so the standard Insert dialog opens instead of the Insert Paste dialog.

How to Clear Copy Mode and the Clipboard in Excel 2016
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.
Before you start

Check whether a moving border still surrounds the copied cells. Distinguish canceling that copy mode from clearing items stored in the Office Clipboard.

Solution 1Recommended

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.

1
Cancel copy mode

In the worksheet, press Esc and check whether the moving border around the copied cells disappears.

2
Open the Clipboard pane

On the Home tab, click the small dialog box launcher in the Clipboard group.

3
Clear stored items

In the Clipboard pane, click Clear All to remove the items listed in the Office Clipboard.

4
Try the insert shortcut

Return to the worksheet, select the target cells, and press Ctrl+Shift+Plus to check which Insert dialog appears.

Cancel copy mode and clear the Office Clipboard
Excel 2010 behavior may not return: Esc may not resolve the reported shortcut behavior. Clearing the Office Clipboard is separate from canceling copy mode, and there is no supported shortcut or setting known to exactly restore Excel 2010's behavior in Excel 2016.
Free Microsoft Office alternative

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.

Edit and organize spreadsheet cells, rows, and columnsOpen and save Microsoft Excel XLS and XLSX filesUse a familiar ribbon-style interfaceMove existing Office files into a lightweight suite
microsoft office alternative - wps office

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.