Excel的keyboard的shortcut key可以在哪裏學到?(如ctrl+c = copy)

2007-09-29 6:14 am
Excel的keyboard的shortcut key可以在哪裏學到?(如ctrl+c = copy)

回答 (2)

2007-09-29 9:42 am
✔ 最佳答案
你在Excel說明內>搜尋「快速鍵」有齊全部「快速鍵」資料及解釋,仲要係中文。
希望幫到你啦!
2007-09-29 7:02 am
You may use the help tool bar, click "help", then choose "Microsoft Excel help", a window will pop up, type "keyboard shortcuts", press enter or the green arrow icon. You will see a list, please choose "keyboard shortcuts" A new window will pop up and showing the keyboard shortcuts. Please click the "+ "sign icon (show all) at the right to show the entire list. Basically those short cut keys also works for microsoft word.

The following are the examples of the common use keyboard shortcuts:

Switch to the next program. ALT+TAB
Switch to the previous program. ALT+SHIFT+TAB
Display the Windows Start menu. CTRL+ESC
Close the selected workbook window. CTRL+W or CTRL+F4
Restore the window size of the selected workbook window. CTRL+F5
When more than one workbook window is open, switch to the next workbook window.CTRL+F6
Switch to the previous workbook window.CTRL+SHIFT+F6
Minimize a workbook window to an icon.CTRL+F9
Maximize or restore the selected workbook window.CTRL+F10
Copy a picture of the screen to the Clipboard.PRTSCR
Copy a picture of the selected window to the Clipboard.ALT+PRINT SCREEN
Insert a new worksheet.SHIFT+F11 or ALT+SHIFT+F1
Move to the next sheet in the workbook.CTRL+PAGE DOWN
Move to the previous sheet in the workbook.CTRL+PAGE UP
Select the current and next sheet. To cancel selection of multiple sheets, press CTRL+PAGE DOWN or, to select a different sheet, press CTRL+PAGE UP.SHIFT+CTRL+PAGE DOWN
Select the current and previous sheet.SHIFT+CTRL+PAGE UP
Rename the current sheet (Format menu, Sheet submenu, Rename command).ALT+O, H, R
Move or copy the current sheet (Edit menu, Move or Copy Sheet command).ALT+E, M
Delete the current sheet (Edit menu, Delete Sheet command).ALT+E, L
Copy the selected cells.CTRL+C
Display the Microsoft Office Clipboard (multiple copy and paste).CTRL+C, immediately followed by another CTRL+C
Cut the selected cells.CTRL+X
Paste copied cells.CTRL+V
Clear the contents of the selected cells.DELETE
Delete the selected cells.CTRL+HYPHEN
Insert blank cells.CTRL+SHIFT+PLUS SIGN
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 values.CTRL+SHIFT+!
Apply or remove bold formatting.CTRL+B
Apply or remove italic formatting.CTRL+I
Apply or remove underlining.CTRL+U
Apply or remove strikethrough.CTRL+5
Hide the selected rows.CTRL+9
Unhide any hidden rows within the selection.CTRL+SHIFT+( (opening parenthesis)
Hide the selected columns.CTRL+0 (zero)
Unhide any hidden columns within the selection.CTRL+SHIFT+) (closing parenthesis)
Apply the outline border to the selected cells.CTRL+SHIFT+&
Remove the outline border from the selected cells.CTRL+SHIFT+_
Apply or remove the top border.ALT+T
Apply or remove the bottom border.ALT+B
Apply or remove the left border.ALT+L
Apply or remove the right border.ALT+R
If cells in multiple rows are selected, apply or remove the horizontal divider.ALT+H
If cells in multiple columns are selected, apply or remove the vertical divider.ALT+V
Apply or remove the downward diagonal border.ALT+D
Apply or remove the upward diagonal border.ALT+U
參考: Microsoft help


收錄日期: 2021-05-03 12:50:08
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070928000051KK04037

檢視 Wayback Machine 備份