XL98: Cannot Use Keyboard to Select Items in Special List in Advanced Search Dialog Box (179645)

SYMPTOMS

In Microsoft Excel 98 Macintosh Edition, it is not possible to use the keyboard to select items in the Special list in the Summary tab in the Advanced Search dialog box. You must use the mouse pointer to select items in this box.

WORKAROUND

When you select an item in the Special list, a corresponding code appears in the Containing Text box. If you cannot select an item in the list, you can type the appropriate code in the Containing Text box. To do this, follow these steps:

Press COMMAND+N to move the insertion point to the Containing Text box.

Enter one or more of the codes in the following table.

      List item             Code
      ---------------------------

      Any Character          ?
      Character Range        [-]
      Beginning of Word      <
      End of Word            >
      Expression             ()
      Not                    [!]
      Num Occurrences        {,}
      Previous 1 or More     @
      0 or More Characters   *

Make any other necessary changes in the box. When you are finished, press RETURN.

MORE INFORMATION

Microsoft Excel 98 Macintosh Edition includes a number of accessibility features that make it possible to use most features of the program even if you cannot use a mouse.

Example

To see an example of the problem described in this article, press the following keys, in order, in Microsoft Excel 98 Macintosh Edition.

   Keystroke   Function
   ----------------------------------------------------
   COMMAND+O   Displays Open dialog box.
   COMMAND+F   Displays Search dialog box.
   COMMAND+A   Displays Advanced Search dialog box.
   COMMAND+S   Selects Summary tab.
   COMMAND+R   Selects Use Pattern Matching check box.