Friday, March 22, 2013

Shortcuts of Excel 2010 (Manage Active Selections - Select inside cells ) Page - 3

Manage Active Selections
F8 Turn on extension of selection with arrow keys without having to keep pressing shift.
Shift+F8 Add another (adjacent or non-adjacent) range of cells to the selection. Use arrow keys and shift+arrow keys to add to selection.
Shift+Backspace Select only the active cell when multiple cells are selected.
Ctrl+Backspace Show active cell within selection.
Ctrl+. (period) Move clockwise to the next corner of the selection.
Enter/Shift+Enter Move active cell down / up in a selection.
Tab/Shift+Tab Move active cell right / left in a selection.
Ctrl+Alt+Arrow Right/Ctrl+Alt+Arrow Left Move to the right / to the left between non-adjacent selections (with multiple ranges selected).
Esc Cancel Selection.
Select inside cells
Shift+Arrow Left/Shift+Arrow Right Select or unselect one character to the left / to the right.
Ctrl+Shift+Arrow Left/Ctrl+Shift+Arrow Right Select or unselect one word to the left / to the right.
Shift+Home/Shift+End Select from the insertion point to the beginning / to the end of the cell.

0 comments:

Post a Comment