Edit Paste Command Causes Loss of Cell Notes in Excel

Last reviewed: November 2, 1994
Article ID: Q70649

SUMMARY

If you copy the contents of a cell that does not contain a cell note into a cell that does contain a note, the existing note is deleted when you choose Paste from the Edit menu, or Paste Special and All from the Edit menu.

To retain existing cell notes when pasting, it is necessary to choose Paste Special and make sure that Skip Blanks is checked if the All option button is checked.

This only happens when choosing Paste from the Edit menu or when choosing Paste Special from the Edit menu and selecting All or Notes. The cell notes will be retained if you choose Paste Special, and any of the options besides All or Notes that include formulas, values, and formats.

KBCategory: kbother
KBSubcategory:
Additional reference words: noupd

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 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.