Excel 快捷键大全(10)

excel shortcut..

LEGEND

for "Anchor" or Ctrl for

Cut Paste Copy and Delete CTRL+C Copy the selected cells. ENTER Immediately after a copy--pastes once and removes the entry from the clipboard CTRL+C, immediately followed by another CTRL+C Display the Microsoft Office Clipboard (multiple copy and paste). CTRL+X Cut the selected cells. CTRL+V Paste copied cells and leaves entry on clipboard (Useful for multiple copies) DELETE Clear the contents of the selected cells. ALT E A A Edit Clear All… cleans everything and returns to the normal style CTRL - (minus sign) Delete the selected cells. CTRL +(plus sign) Insert blank cells.

ders for objects.

Formatting Data ALT+' (apostrophe) Display the Style dialog box. CTRL+1 Display the Format Cells dialog box. CTRL+SHIFT+~ Apply the General number format. CTRL+SHIFT+$ Apply the Currency format with two decimal places (negative numbers in parentheses). CTRL+SHIFT+% Apply the Percentage format with no decimal places. CTRL+SHIFT+^ Apply the Exponential number format with two decimal places. CTRL+SHIFT+# Apply the Date format with the day, month, and year. CTRL+SHIFT+@ Apply the Time format with the hour and minute, and AM or PM. CTRL+SHIFT+! Apply the Number format with two decimal places, thousands separator, and minus sign (–) for negative v CTRL+B Apply or remove bold formatting. CTRL+I Apply or remove italic formatting. CTRL+U Apply or remove underlining. CTRL+5 Apply or remove strikethrough. CTRL+9

Cut Paste Copy and DeleteCTRL+CCopy the selected cells.

ENTER

Immediately after a copy--pastes once and removes the entry from the clipboard

CTRL+C, immediately followed by another CTRL+C

Display the Microsoft Office Clipboard (multiple copy and paste).

CTRL+X

Cut the selected cells.

CTRL+V

Paste copied cells and leaves entry on clipboard (Useful for multiple copies)

DELETE

Clear the contents of the selected cells.

ALT E A A

Edit Clear All… cleans everything and returns to the normal style

CTRL - (minus sign)

Delete the selected cells.

CTRL +(plus sign)

Insert blank cells.

Formatting Data

ALT+' (apostrophe)

Display the Style dialog box.

CTRL+1

Display the Format Cells dialog box.

CTRL+SHIFT+~

Apply the General number format.

CTRL+SHIFT+$

Apply the Currency format with two decimal places (negative numbers in parentheses).

CTRL+SHIFT+%

Apply the Percentage format with no decimal places.

CTRL+SHIFT+^

Apply the Exponential number format with two decimal places.

CTRL+SHIFT+#

Apply the Date format with the day, month, and year.

CTRL+SHIFT+@

Apply the Time format with the hour and minute, and AM or PM.

CTRL+SHIFT+!

Apply the Number format with two decimal places, thousands separator, and minu

CTRL+B

Apply or remove bold formatting.

CTRL+I

Apply or remove italic formatting.

CTRL+U

Apply or remove underlining.

CTRL+5

Apply or remove strikethrough.

CTRL+9ders for objects.