40 个最佳 Microsoft Excel 键盘快捷键

Microsoft Excel是一种多功能软件,旨在帮助以专业方式或在日常生活中处理电子表格和数据的每个人。它允许您组织和存储数据,并且可以使用公式和函数执行复杂的数学计算。(mathematical calculations)更酷的是,Excel还可以通过饼图(pie charts)甘特图(Gantt charts)流程图(flowcharts)以及几乎所有你能想象到的图表来帮助你可视化你的数据和项目。

Microsoft Excel最初是在考虑数据输入的情况下开发的,但从那时起,该软件逐渐适应了从会计、任务管理和财务建模到事件编程的所有内容。这意味着它不是最简单的软件。要在Excel中高效工作,您需要使用键盘快捷键,这就是我们将在本文中重点介绍的内容。

为什么需要键盘快捷键?

即使您知道Microsoft Excel是什么并且您过去曾广泛使用过它,您仍然可能会对可用于快速高效工作的所有功能和快捷方式感到惊讶。Excel有数百个快捷键和按键组合,但不用担心,您不需要记住所有这些。

您将比其他人更频繁地使用某些Excel快捷方式。(Excel)因此,让我们专注于您每天需要的最重要的那些。

常用的 Excel 快捷方式

您可能熟悉一些快捷方式,因为它们通常在大多数 Windows 10/11 和Microsoft Office应用程序中使用。尽管如此,这里有一个有用的表格,其中包含您需要开始使用 的最常用的Excel键盘快捷键,以快速提高您对电子表格的掌握程度。(Excel)

Ctrl+ASelect all
Ctrl+CCopy
Ctrl+VPaste
Ctrl+XCut
Ctrl+ZUndo
Ctrl+YRedo
Ctrl+BBold
Ctrl+IItalicize
Ctrl+UUnderline
Alt+HGo to the Home tab
Delete (or DEL)Remove content in the cell
Ctrl+OOpen a workbook
Ctrl+WClose a workbook
Alt+H+HChoose a color to fill the cell

这些快捷方式很方便,您应该习惯于不仅在Excel中使用它们,而且在Microsoft Word互联网浏览器(internet browsers)或您经常用于商务或休闲的任何其他应用程序中使用它们。

Excel 中的数据透视表快捷方式

数据透视表(Pivot Table)Excel中的一个强大工具。它可以汇总电子表格中选定的行和列,甚至重新组织它们。如果您有很长的数据行需要汇总,数据透视表很方便,并且它们还允许您比较数据。如果您发现自己使用了许多数据透视表,请定期开始使用下面的快捷方式。

Right-clickAccess the context menu for the selected row, column, or cell.
Ctrl+DDelete the table
Ctrl+MMove the table
Ctrl+RRename the table
Alt+Shift+Right ArrowGroup the pivot table items you selected
Alt+Shift+Left ArrowUngroup the pivot table items you selected

现在您已经了解了基本快捷键,让我们关注可以提高您的工作效率和速度的其他Excel键盘快捷键。(Excel)

在 Excel 中导航的快捷方式

(Navigate)使用以下键盘快捷键更快地浏览 Excel 并在工作表选项卡之间切换(Excel)

Ctrl+Page UpPress this command combination to switch the worksheet tabs to the right.
Ctrl+Page DownThis command will switch the worksheet tabs to the left.
Ctrl+BackspaceThis shortcut will show you which cell is active.
F11The F11 key will create a new chart. It is an amazing shortcut that will allow you to skip all the navigation through Excel’s toolbar.
Ctrl+FPress this combination of keys to quickly access the find function.
Ctrl+QQuickly access the Help function in Excel.
Ctrl+Arrow KeyGo to the last populated cell in the direction of the arrow key. For example, Ctrl+Right Arrow will send you to the last cell to the right, while Ctrl+Down Arrow will select the last cell at the bottom.
 Ctrl+F12This command quickly opens the “open file” dialog and allows you to access another workbook.
Ctrl+F1This combination of keys will toggle the display of ribbons.

(Shortcuts)Excel中选择项目的(Items)快捷方式

通过使用以下键盘快捷键而不是笨拙的鼠标移动来更快地选择列和行,从而节省时间。

Ctrl+SpacebarPress Ctrl+Space to select the entire column. You will no longer need to use the header and navigate with your mouse.
Shift+SpacebarPress Shift+Space to select the whole row.
Ctrl+0This simple shortcut will hide all the selected columns.

(Shortcuts)Excel函数(Functions)公式(Formulas)快捷方式

Excel主要是关于公式和函数。停止(Stop)逐个变量地键入它们,并使用下面的键盘快捷键提高您的工作效率。

Ctrl+’Switch between displaying all the formulas in your worksheet. Also, you can click on the cell to have the formula shown in the formula bar.
Ctrl+Alt+F9Use this shortcut when you need to calculate all the formulas inside all of your active workbooks.
Ctrl+Shift+$To automatically change a cell into the currency format, you must select it and press Ctrl+Shift+$. It can also work on multiple cells as long as they are selected.
Ctrl+Shift+%This shortcut applies the percentage format to the selected cell.
Alt+=This shortcut will automatically insert the SUM() function. This is possibly the most used formula in Excel, and having a shortcut for it is a must. The Sum() function auto-sums the data of multiple columns and rows. Just make sure to select one extra column on the right side and one extra row on the bottom. Excel will use these to display the summation data.
Alt+H+O+IThis shortcut is a combination of keystrokes that will complete a function in a sequence. First, hit Alt+H to select the Home tab, then hit the O while still holding the Alt key to select the format menu. Finally, hit the I to autofit the width of the column. Remember to keep your finger on Alt while pressing each letter.
Ctrl+[This shortcut allows you to see what cells are referenced in other cells. It is especially useful if you are working with complex formulas.
Ctrl+Shift+JUse this shortcut to see a list of all the constants in your worksheet.
Alt+MOpen the formulas tab.
Shift+F3Prest Shift+F3 to open the insert function window to insert a function.

Excel 中的时间和日期快捷方式

(Log)使用下面的时间和日期键盘快捷键立即记录各种活动。

Ctrl+Shift+#This shortcut will allow you to change the date format.
Ctrl+Shift+@Hitting the combination of these keys will allow you quick access to the time of day style. From here, you can proceed and add it to the selected cell.
 Ctrl+;Do you want to add the current date to the Excel spreadsheet? Simply hit this shortcut to add it quickly.
Ctrl+Shift+;This function will place the exact current time in the selected cell.

在 Excel 中编辑快捷方式

编辑单元格、行、列和注释可能非常耗时。使用以下快捷方式提高您的速度。

Ctrl+1Open the format cell dialog box. This shortcut will allow you to make changes to the cell’s appearance.
Ctrl+KIf you select a cell or the data entered in the cell and use this shortcut, a hyperlink box will open. Copy and paste the hyperlink into the box (using the copy/paste shortcuts for extra practice).
F2This must be one of the most used Excel shortcuts as it will allow you to edit the cell. Use it to make quick changes.
F4The F4 key will repeat your last action. Be it a formula or an edit, this key will copy the action and save you a lot of time.
Ctrl+Plus Character (+)Insert new rows and columns quickly with the Ctrl shortcut.
Ctrl+Minus Character (-)Press Ctrl+- to delete a row or a column.
Shift+F2Insert a comment or edit an existing comment in a selected cell.

在 Excel 中格式化快捷方式

格式化您的Excel数据使其具有可读性和可展示性。但这并不意味着您应该浪费时间,所以开始使用下面的快捷方式。

Ctrl+Shift+&This Excel shortcut quickly applies borders to the selected cell. This is very helpful if you want to keep your spreadsheet neatly organized and visually appealing.
Ctrl+Shift+_To quickly remove the borders, select the desired cells and hit this combination of keys.
 Ctrl+Shift+~This combination of keys will style a selected cell or a group of cells into a general format. Keep in mind the general format is the default format, meaning you get the numbers you type and nothing else.
Ctrl+Shift+^This command applies the exponential format to the cell you select.
Ctrl+Shift+!This shortcut applies the comma formatting style to the selected cell. For example, when the number in the cell goes over 1000, this command will display it with a comma as 1,000. Use this shortcut to visualize numbers.

无论您是电子表格大师还是使用过Excel一次,知道一些快捷方式将使您的工作更轻松,更省时。在下面的评论中分享您最喜欢的Excel键盘快捷键和组合!



About the author

我是一位强烈推荐的 Windows 10 专家,我专注于帮助人们个性化他们的计算机外观并使他们的 Office 工具更加用户友好。我利用自己的技能帮助他人找到使用 Microsoft Office 的最有效方法,包括如何格式化文本和图形以进行在线打印、如何为 Outlook 创建自定义主题,甚至如何自定义桌面任务栏的外观计算机。



Related posts