Excel: Recalculating or Choosing Command Clears Clipboard

 Last reviewed: March 15, 1995
Article ID: Q58228
The information in this article applies to:
  • Microsoft Excel for the Macintosh, versions 1.x, 2.x, 3.0, 4.0
  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a
  • Microsoft Excel for OS/2, versions 2.2, 3.0

SUMMARY

When you Cut or Copy data in Microsoft Excel, a description of the operation and the selection on is maintained the internal Clipboard. For example "Cut 1R x 1C" indicates that a selection of one row by one column has been cut.

Microsoft Excel clears the internal Clipboard when most commands other than Paste or Paste Special are used or when the worksheet is recalculated immediately following a Cut or Copy operation. Any information currently in the Clipboard (other than external copied information) is lost. If the moving border surrounding the currently cut or copied information stops moving, the internal Clipboard contents have been cleared.

Commands that do not affect the Clipboard include: commands on the Window menu; and New, Open, Close, and Links (on the File menu).

MORE INFORMATION

Macintosh Version Only

In Microsoft Excel for the Macintosh, you can externalize the Clipboard, to allow the copied data to be retained in the Clipboard until another Copy operation is executed. To externalize the Clipboard, do the following:

  1. Select the area to be copied.

  2. From the Edit menu, choose Copy.

  3. From the Apple menu, choose Scrapbook.

  4. From the Edit menu, choose Paste.

The desired editing commands can now be executed and the Clipboard will not be cleared. The data can be pasted repeatedly until another Copy is executed.

Another way to externalize the Clipboard is to using MultiFinder to switch to the Finder and then switch back to Microsoft Excel.

KBCategory: kbusage
KBSubcategory:

Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.00 2.01 2.10 2.20
3.00 4.00 4.00a



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: March 15, 1995
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.