Microsoft KB Archive/282160

= The watched cell is removed from the Watch Window dialog box in Excel when you cut the contents from another cell and then paste the contents into the watched cell =

Article ID: 282160

Article Last Modified on 2/6/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q282160



SYMPTOMS
In Microsoft Excel, a watched cell is removed from the Watch Window dialog box. If you click Undo, the watched cell remains removed from the Watch Window dialog box.

This issue occurs when you add a cell to the Watch Window dialog box as the watched cell, use the Cut command to delete the contents from another cell, and then use the Paste command to add the contents into the watched cell,



CAUSE
This issue occurs when you use the Cut command on the Edit menu and then paste the data into a watched cell.



RESOLUTION
To resolve this issue, use the Copy and Paste commands instead of Cut and Paste. You can then delete or cut data from the copied cell, and the pasted cell remains in the Watch Window, as in the following example:   Start Excel and then create the following worksheet:   A1:    B1: 1 A2:   B2: 2 A3:   B3: 3 A4:   B4: 4  On the View menu, point to Toolbars, and then click Watch Window.

Note In Microsoft Office Excel 2007, click Watch Window in the Formula Auditing group on the Formulas tab. Select cells A1:A4. In the Watch Window dialog box, click Add Watch. In the Add Watch dialog box, click Add.

Notice that Cells A1:A4 are present in the Watch Window. Select cell B1.</li> On the Edit menu, click Copy.

Note In Excel 2007, click Copy in the Clipboard group on the Home tab.</li> Select cell A1.</li> On the Edit menu, click Paste.

Note In Excel 2007, click Paste in the Clipboard group on the Home tab.

Notice that the contents of cell B1 are pasted to cell A1, and that cell A1 is still present in the Watch Window.</li> Select cell B1.</li> On the Edit menu, point to Clear, and then click Contents.

In Excel 2007, click Clear Contents on the Quick Access Toolbar.

Note

To show the Clear Contents command on the Quick Access Toolbar in Excel 2007, follow these steps: <ol style="list-style-type: lower-alpha;"> Click the Microsoft Office Button, and then click Excel Options.</li> Click Customize.</li> In the Choose commands from box, click All Commands.</li> Click Clear Contents in the list, click Add, and then click OK.</li></ol> </li></ol>

Notice that the cell contents are deleted from cell B1, but that cell A1 is still in the Watch Window.

<div class="workaround_section">

WORKAROUND
To work around this issue, add any removed cells back into the Watch Window. To do this, follow these steps:
 * 1) Select the cell or cells that you want to watch.
 * 2) In the Watch Window dialog box, click Add Watch.
 * 3) In the Add Watch dialog box, click Add.

<div class="moreinformation_section">

Steps to reproduce the problem
<ol>  Start Excel and then create the following worksheet: <pre class="fixed_text">  A1:    B1: 1 A2:   B2: 2 A3:   B3: 3 A4:   B4: 4 </li> On the View menu, point to Toolbars, and then click Watch Window.

Note In Excel 2007, click Watch Window in the Formula Auditing group on the Formulas tab.</li> Select cells A1:A4.</li> In the Watch Window dialog box, click Add Watch.</li> In the Add Watch dialog box, click Add.

Notice that Cells A1:A4 are present in the Watch Window.</li> Select cell B1.</li> <li>On the Edit menu, click Cut.

Note In Excel 2007, click Cut in the Clipboard group on the Home tab.</li> <li>Select cell A1.</li> <li>On the Edit menu, click Paste.

Note In Excel 2007, click Paste in the Clipboard group on the Home tab.

Notice that the contents of cell B1 are pasted to cell A1, and that cell A1 is removed from the Watch Window.</li> <li>On the Edit menu, click Undo Paste.

Note In Excel 2007, click Undo on the Quick Access Toolbar.</li></ol>

Notice that the cell contents return to cell B1, but that cell A1 is still removed from the Watch Window.

Additional query words: XL2002 prb debug XL2003 XL2007

Keywords: kbexpertisebeginner kbtshoot kbpending kbprb KB282160

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.