I
found some Shortcuts for filtering, outlining, and managing lists with
worksheet in MS-Excel. Use the Simple Shortcut keys to play the work when you
are creating Work books in the MS-Excel Application. These tips may make your
work easier.
Use data forms
(Data menu, Form command)
DOWN
ARROW - Move to the same field in the next record.
UP
ARROW - Move to the same field in the previous record.
TAB
and SHIFT+TAB - Move to each field in the record, then to each command button.
ENTER
- Move to the first field in the next record.
SHIFT+ENTER
- Move to the first field in the previous record.
PAGE
DOWN - Move to the same field 10 records forward.
CTRL+PAGE
DOWN - Start a new, blank record.
PAGE
UP - Move to the same field 10 records back.
CTRL+PAGE
UP - Move to the first record.
HOME
or END - Move to the beginning or end of a field.
SHIFT+END
- Extend selection to the end of a field.
SHIFT+HOME
- Extend selection to the beginning of a field.
LEFT
ARROW or RIGHT ARROW - Move one character left or right within a field.
SHIFT+LEFT
ARROW - Select the character to the left within a field.
SHIFT+RIGHT
ARROW - Select the character to the right within a field.
Filter
lists (Data menu, AutoFilter command)
ALT+DOWN
ARROW - In the cell that contains the drop-down arrow, displays the AutoFilter
list for the current column.
DOWN
ARROW - Selects the next item in the AutoFilter list.
UP
ARROW - Selects the previous item in the AutoFilter list.
ALT+UP
ARROW - Closes the AutoFilter list for the current column.
HOME
- Selects the first item (All) in the AutoFilter list.
END
- Selects the last item in the AutoFilter list.
ENTER
– Filters the list based on the item selected from the AutoFilter list.
Show, hide, and
outline data
ALT+SHIFT+RIGHT
ARROW - Groups rows or columns.
ALT+SHIFT+LEFT
ARROW - Ungroups rows or columns.
CTRL+8
- Displays or hides the outline symbols.
CTRL+9
- Hides the selected rows.
CTRL+SHIFT+(
(opening parenthesis) - Unhides any hidden rows within the selection.
CTRL+0
(zero) - Hides the selected columns.
CTRL+SHIFT+)
(closing parenthesis) - Unhides any hidden columns within the selection.
Please leave a comment if you like my
article
0 comments:
Post a Comment