Excel: Paste Command Unavailable when Copying Range of Cells

 Last reviewed: November 4, 1994
Article ID: Q93177
The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.1, 3.0, 4.0, 4.0a, 5.0

SUMMARY

When you copy a range of cells from a worksheet, Microsoft Excel for Windows uses a "fast copy" method. This "fast copy" method results in faster copying and lower memory consumption. However, "fast copy" also increases the possibility that cell data will be lost from the clipboard and the Paste command on the Edit menu will be unavailable from the Edit menu.

MORE INFORMATION

When you copy a range of cells from a Microsoft Excel for Windows worksheet to the clipboard, Microsoft Excel places a reference to those worksheet cells in the clipboard (it does not copy the actual data from the cells). This method of storing data is faster because placing a reference in the clipboard takes less time and uses less memory than placing the actual data in the clipboard.

When the clipboard contains cell data, you will see a moving border around the cells in the Excel worksheet and the following message will appear in the status bar: 

   Select destination and press ENTER or choose Paste
As long as the moving border is visible and the above message appears in the status bar, the reference to the cells exists in the clipboard. If you press the ESC key or choose another menu command, the reference to the cells is removed from the clipboard and the Paste command on the Edit menu is be unavailable (dimmed).

Workarounds

To copy the actual cell contents to the clipboard, use one of the following methods.

To copy data from one cell

  1. Select the cell.

  2. In the formula bar, select the cell data.

  3. From the Edit menu, choose Copy.

  4. To exit the formula bar, press the ESC key.

To copy data from a range of cells

  1. Select the range of cells.

  2. From the Edit menu, choose Copy.

  3. Open a text editor (such as Windows Notepad).

  4. Paste the data in a new text editor document.

REFERENCES

"Microsoft Excel User's Guide 1," version 4.0, pages 360-361.

KBCategory: kbusage
KBSubcategory:

Additional reference words: 5.00 2.1 2.10 2.1c 2.10c 2.1d 2.10d 3.0 3.00
4.0 4.00 gray grayed grey greyed

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 4, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.