Excel 简明教程

Keyboard Shortcuts in Excel 2010

MS Excel Keyboard Short-cuts

MS Excel 提供了多种键盘快捷键。如果你熟悉 Windows 操作系统，你应该知道它们中的大多数。以下是微软 Excel 中所有主要快捷键的列表。

MS Excel offers many keyboard short-cuts. If you are familiar with windows operating system, you should be aware of most of them. Below is the list of all the major shortcut keys in Microsoft Excel.

  1. Ctrl + A − Selects all contents of the worksheet.

  2. Ctrl + B − Bold highlighted selection.

  3. Ctrl + I − Italicizes the highlighted selection.

  4. Ctrl + K − Inserts link.

  5. Ctrl + U − Underlines the highlighted selection.

  6. Ctrl + 1 − Changes the format of selected cells.

  7. Ctrl + 5 − Strikethrough the highlighted selection.

  8. Ctrl + P − Brings up the print dialog box to begin printing.

  9. Ctrl + Z − Undo last action.

  10. Ctrl + F3 − Opens Excel Name Manager.

  11. Ctrl + F9 − Minimizes the current window.

  12. Ctrl + F10 − Maximize currently selected window.

  13. Ctrl + F6 − Switches between open workbooks or windows.

  14. Ctrl + Page up − Moves between Excel work sheets in the same Excel document.

  15. Ctrl + Page down − Moves between Excel work sheets in the same Excel document.

  16. Ctrl + Tab − Moves between Two or more open Excel files.

  17. Alt + = − Creates a formula to sum all of the above cells

  18. Ctrl + ' − Inserts the value of the above cell into cell currently selected.

  19. Ctrl + Shift + ! − Formats the number in comma format.

  20. Ctrl + Shift + $ − Formats the number in currency format.

  21. Ctrl + Shift + # − Formats the number in date format.

  22. Ctrl + Shift + % − Formats the number in percentage format.

  23. Ctrl + Shift + ^ − Formats the number in scientific format.

  24. Ctrl + Shift + @ − Formats the number in time format.

  25. Ctrl + Arrow key − Moves to the next section of text.

  26. Ctrl + Space − Selects the entire column.

  27. Shift + Space − Selects the entire row.

  28. Ctrl + - − Deletes the selected column or row.

  29. Ctrl + Shift + = − Inserts a new column or row.

  30. Ctrl + Home − Moves to cell A1.

  31. Ctrl + ~ − Switches between showing Excel formulas or their values in cells.

  32. F2 − Edits the selected cell.

  33. F3 − After a name has been created F3 will paste names.

  34. F4 − Repeat last action. For example, if you changed the color of text in another cell pressing F4 will change the text in cell to the same color.

  35. F5 − Goes to a specific cell. For example, C6.

  36. F7 − Spell checks the selected text or document.

  37. F11 − Creates chart from the selected data.

  38. Ctrl + Shift + ; − Enters the current time.

  39. Ctrl + ; − Enters the current date.

  40. Alt + Shift + F1 − Inserts New Worksheet.

  41. Alt + Enter − While typing text in a cell pressing Alt + Enter will move to the next line allowing for multiple lines of text in one cell.

  42. Shift + F3 − Opens the Excel formula window.

  43. Shift + F5 − Brings up the search box.