Select cells or chart items by using shortcut keys
Select cells, columns, or rows in datasheets by using shortcut keys
Press | To |
CTRL+SPACEBAR | Select the entire column |
SHIFT+SPACEBAR | Select the entire row |
CTRL+A | Select the entire datasheet |
F8 | Turn extend mode on or off |
SHIFT+ arrow key | Extend the selection by one cell |
CTRL+SHIFT+ arrow key | Extend the selection to the last nonblank cell in the same column or row of the active cell |
SHIFT+HOME | Extend the selection to the beginning of the row |
CTRL+SHIFT+HOME | Extend the selection to the upper left corner cell of the datasheet |
CTRL+SHIFT+END | Extend the selection to the last cell used in the datasheet (lower-right corner) |
SHIFT+PAGE DOWN | Extend the selection down one screen |
SHIFT+PAGE UP | Extend the selection up one screen |
SHIFT+BACKSPACE | If multiple cells are selected, select only the active cell |
Select chart items by using shortcut keys
Press | To |
DOWN ARROW | Select the previous group of items |
UP ARROW | Select the next group of items |
RIGHT ARROW | Select the next item within the group |
LEFT ARROW | Select the previous item within the group |
No comments:
Post a Comment