XL98: "Insert Copied Cells" Menu Item Missing After Copy (221227)


The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition
This article was previously published under Q221227

SYMPTOMS

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 hold down CONTROL and click a cell.

CAUSE

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.

WORKAROUND

To work around this problem, select the range, hold down CONTROL and click the edge of the selection, and drag the selection. A menu appears that lets you choose whether to shift cells down or right, and whether to copy (paste) the selection or to move it. You need to reselect the cells to repeat the action.

MORE INFORMATION

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.

REFERENCES

For more information about inserting copied cells, follow these steps:
  1. On the Help menu, click Contents and Index. If you are using a version of the Macintosh operating system that is earlier than 8.0, click Contents and Index on the Balloon Help menu.
  2. In Excel Help, click Index, and then type the following text:

    inserting cells

  3. Click Show Topics. Click the Insert cells, rows, or columns topic, and then click Go To.
If you cannot find the information that you want, ask the Office Assistant.

Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbprb KB221227
©2002 Microsoft Corporation. All rights reserved.