Excel 快捷键大全(11)

excel shortcut..

Hide the selected rows.

CTRL+SHIFT+( (opening parenthesis)

Unhide any hidden rows within the selection.

CTRL+0 (zero)

Hide the selected columns.

CTRL+SHIFT+) (closing parenthesis)

Unhide any hidden columns within the selection.

CTRL+SHIFT+&

Apply the outline border to the selected cells.

CTRL+SHIFT+_

Remove the outline border from the selected cells.

Formatting Borders --Select Format cells… move to the Borders tab, then…

ALT+T

Apply or remove the top border.

ALT+B

Apply or remove the bottom border.

ALT+L

Apply or remove the left border.

ALT+R

Apply or remove the right border.

ALT+H

If cells in multiple rows are selected, apply or remove the horizontal divider.

ALT+V

If cells in multiple columns are selected, apply or remove the vertical divider.

ALT+D

Apply or remove the downward diagonal border.

ALT+U

Apply or remove the upward diagonal border.

Keys used in AUTOFILTER

ALT+DOWN ARROW

In the cell that contains the drop-down arrow, displays the AutoFilter list for the cur

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.

Keys Used with OUTLINING

ALT+SHIFT+RIGHT ARROW

Groups rows or columns.

ALT+SHIFT+LEFT ARROW Enter" is turned off).