Microsoft KB Archive/288981

= HOW TO: Use Speech Recognition to Select Cells, Rows, and Columns in Excel =

Article ID: 288981

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q288981



IN THIS TASK
SUMMARY
 * Enable Speech Recognition
 * Select the Current Column
 * Select the Current Row
 * Use the Extend Mode to Select a Specific Range of Cells
 * Select the Current Region
 * Select a Named Region
 * Select Other Special Types of Cells

REFERENCES



SUMMARY
This step-by-step article explains how to use speech recognition in conjunction with the keyboard to select a range of cells, rows, and columns. This article shows you how to:
 * Select the current row.
 * Select the current column.
 * Select a specific range of cells by using the extend mode (F8).
 * Select the current region with the Go To command.
 * Select a named region with the Go To command.
 * Select other special types of cells with the Go To command.

back to the top

Enable Speech Recognition
To perform the tasks listed later in this article, turn speech recognition on, and then click Voice Command on the Language bar. To turn speech recognition on, point to Speech on the Tools menu, and then click Speech Recognition.

back to the top

Select the Current Column
Press and hold CTRL and say &quot;Spacebar&quot;.

back to the top

Select the Current Row
Press and hold SHIFT and say &quot;Spacebar&quot;.

back to the top

Select a Specific Range of Cells, Using the Extend Mode
Press F8 to turn extend mode on. In extend mode, EXT appears in the status line, and Excel extends the selection manually when you press an ARROW key or a combination of keys that move the active cell to a different location on your worksheet. You can extend the selection in the same way with speech recognition by using the following voice commands after you press F8:

ARROW keys (say &quot;DOWN&quot;, or &quot;RIGHT&quot;, or &quot;UP&quot;, or &quot;LEFT&quot;)

say &quot;HOME&quot;

say &quot;END&quot;

say &quot;PAGE UP&quot;

say &quot;PAGE DOWN&quot;

You can also change the effect of the voice commands by pressing and holding the CTRL key. The following table outlines selection options that are available after you press F8.

NOTE: CTRL+&quot;HOME&quot; indicates that you are to press and hold the CTRL key and say &quot;HOME&quot;, after you press F8.

  Voice command,    Action or CTRL+ voice command, or keyboard --  arrow key        Extend the selection by one cell.

CTRL+arrow key  Extend the selection to the last nonblank cell in the same column or row as the active cell.

&quot;HOME&quot;          Extend the selection to the beginning of the row.

CTRL+&quot;HOME&quot;     Extend the selection to the beginning of the worksheet.

&quot;END&quot;           Extend the selection to the last of the row.

CTRL+&quot;END&quot;      Extend the selection to the last used cell on the worksheet (lower-right corner).

&quot;PAGE DOWN&quot;     Extend the selection down one screen.

&quot;PAGE UP&quot;       Extend the selection up one screen. back to the top

Select the Current Region
Say &quot;Edit&quot;, say &quot;Go To&quot;, say &quot;Special&quot;, and then say &quot;Current region&quot;. Say &quot;OK&quot; to accept your selection.

back to the top

Select a Named Region
Say &quot;Edit&quot;, say &quot;Go To&quot;, and then say the name of any region that is defined in your workbook. Say &quot;OK&quot; to accept your selection. For example, to select the defined Print Area of your worksheet, say &quot;Edit&quot;, say &quot;Go To&quot;, say &quot;Print Area&quot;, and then say &quot;OK&quot;.

back to the top

Select Other Special Types of Cells
Say &quot;Edit&quot;, say &quot;Go To&quot;, and then say &quot;Special&quot;. In the Go To Special dialog box, you can use the following voice commands to make selections:

&quot;Comments&quot;

&quot;Constants

&quot;Formulas&quot; (and then &quot;Numbers&quot;, &quot;Text&quot;, &quot;Logicals&quot;, or &quot;Errors&quot;)

&quot;Blanks&quot;

&quot;Current region&quot;

&quot;Current array&quot;

&quot;Objects&quot;

&quot;Row difference&quot;

&quot;Column differences&quot;

&quot;Precedents&quot;

&quot;Dependents&quot; (and then &quot;Direct only&quot; or &quot;All levels&quot;)

&quot;Last cell&quot;

&quot;Visible cells only&quot;

&quot;Conditional formats&quot;

&quot;Data validation&quot; (and then &quot;All&quot; or &quot;Same&quot;)

back to the top

