XL2000: Double-Clicking Cell Doesn't Display Notes or Precedents (214309)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q214309

SYMPTOMS

In Microsoft Excel, when you double-click a cell that contains a note, a link to another worksheet, or a precedent, a flashing bar appears in the cell. The note, linked worksheet, or precedent is not displayed when you double-click the cell.

CAUSE

In Microsoft Excel, when you double-click a cell, a flashing bar appears, and then you can edit directly in the cell. If you want to display cell notes or select a cell's precedents, use one of the workarounds in this article.

WORKAROUND

To work around this problem, do one of the following:

Method 1: Clearing the "Edit directly in cell" Check Box

  1. On the Tools menu, click Options.
  2. Click the Edit tab.
  3. Click to clear the Edit directly in cell check box.
  4. Click OK.
After you clear this option, when you double-click a cell, the note is displayed or the linked information or precedents are selected.

Method 2: Using the Auditing Toolbar

  1. On the View menu, point to Toolbars and click Customize.
  2. Click the Toolbars tab.
  3. Click the Auditing toolbar.
  4. Click Close.
Instead of double-clicking a cell to select precedents, you can now use the Trace Precedents button located on the Auditing toolbar.

Method 3: Displaying the Cell Note

You can display and edit a cell note by pressing SHIFT+F2.
Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbprb KB214309
©2003 Microsoft Corporation. All rights reserved.