WD2000: Clicking Selects Multiple Cells in Embedded Excel Worksheet

ID: Q189153


The information in this article applies to:
  • Microsoft Word 2000


SYMPTOMS

In Microsoft Word, when you click a cell in an embedded Microsoft Excel worksheet, multiple cells are selected. Repeatedly clicking in other cells continues to select cells instead of clearing the current selection.

This action is similar to holding down the SHIFT key while you click in a different section of the worksheet.

Other symptoms include loss of characters and characters changing between uppercase and lowercase.


CAUSE

The possible causes for this problem include the following:

  • The SHIFT key is stuck in the down position.

    -or-


  • The extend selection mode is turned on.

    -or-


  • All Caps formatting is turned on.


WORKAROUND

To work around this problem, use the appropriate method for your situation.

Method 1: Stuck SHIFT Key

Check to see whether either SHIFT key is stuck in the down position on your keyboard.

Method 2: Turn Off Extend Mode

If EXT appears bold in your status bar, press ESC on your keyboard and then click somewhere in your document to turn off any selection.

Method 3: Turn Off All Caps Formatting

To turn off All Caps formatting, follow these steps:
  1. Select any words that are in all capital letters.


  2. On the Format menu, click Font.


  3. Click to clear the All caps check box.



STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


MORE INFORMATION

The following table lists ways you can extend a selection.


   To do this                             Press this key
   ------------------------------------------------------------------------

   Turn extend mode on                    F8

   Select the nearest character           F8, and then press the LEFT ARROW
                                          key or the RIGHT ARROW key

   Increase the size of a selection       F8 (press once to select a
                                          word, twice to select a sentence,
                                          and so forth)

   Reduce the size of a selection         SHIFT+F8

   Turn extend mode off                   ESC 

Additional query words: highlight select many shift cells loss missing characters case change embedded OLE winword Graph spreadsheet

Keywords : kbole kbdta wd2000
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: July 15, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.