Excel: Results of AutoSelect Different from CTRL+ArrowLast reviewed: November 30, 1994Article ID: Q81815 |
The information in this article applies to:
SUMMARYIn Microsoft Excel, you can double-click any border of the active cell to move the selection. When you press SHIFT and double-click any border in the cell, you extend the selection. This feature is called "AutoSelect." When you double-click any of the cell's borders, Microsoft Excel moves the active selection in that direction (if possible). Using this feature is similar to using CTRL+ARROW (to move the active cell) and SHIFT+CTRL+ the UP, DOWN, LEFT, or RIGHT ARROW keys (to extend a selection).
MORE INFORMATIONWhen you use AutoSelect, the cell you move to and the cells that are selected may be different from those that are selected when you use CTRL with the arrow keys. Two factors that affect the behavior of the AutoSelect feature are the following:
Also, CTRL+ARROW will move to the end of the worksheet (row 16384 or column IV) if all the cells in the direction you select are blank. AutoSelect will not move the active cell if all of the cells in the direction you select are blank.
Example
NOTE: To select cells using AutoSelect, hold down the SHIFT key while double-clicking the border of the active cell. Excel will select the range of cells from the active cell to the last cell selected.
STATUSThis behavior is by design in Microsoft Excel version 4.0. The algorithm was modified this way intentionally to provide greater utility value to both selection and navigation.
REFERENCES"User's Guide," version 5.0, pages 94-96 "User's Guide 1," version 4.0, pages 96-97
|
KBCategory: kbusage
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |