After you copy a range of cells, the Copied Cells menu item may be missing from the Insert menu. The Insert Copied Cells menu item is also missing on the shortcut menu when you right-click a cell.
↑ Back to the top
This problem occurs if you do either of the following after the copy operation:
- You paste the copied selection.
-or-
- You use the Copied Cells menu item on the Insert menu, or the Insert Copied Cells shortcut menu item.
↑ Back to the top
To work around this problem, select the range, hold down CTRL+SHIFT, click the edge of the selection, and drag the selection to copy it. You need to reselect the cells to repeat the action.
You do not get an Insert Paste dialog box that allows you to choose whether to move cells to the right or down. However, you can make this choice by positioning the mouse and watching the insertion icon. A vertical bar indicates that cells will be moved to the right. A horizontal bar indicates that cells will be moved down.
↑ Back to the top
Although the menu items are missing, the copied cell information is still on the Clipboard. The Paste menu item is still available and you can continue to paste the copied selection.
↑ Back to the top
For more information about keyboard shortcuts, click Microsoft Excel Help on the Help menu, type Keyboard shortcuts in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
↑ Back to the top