(Keyboard shortcuts)Excel中的键盘快捷键旨在让您的生活更轻松。它们缩短了执行某些任务、动作和命令所需的时间。如果您拥有Mac并在日常生活中使用 Microsoft Excel ,那么本文中的快捷方式可以提高您的工作效率。(Excel)
我们重点介绍了Mac上用于格式化数据、编辑数据输入、导航工作表、管理文件等的一些最佳(Mac)Excel快捷方式。您还会发现许多Excel用户经常使用的常用快捷方式。
最重要的是,我们还包括在Excel中创建您自己的自定义键盘快捷键的步骤。
导航快捷方式
在Excel(Excel)中移动工作表或工作簿有时会很困难,尤其是在处理庞大的数据集时。这些快捷方式可以使导航更轻松、更快捷。
1. 跳到工作表的开头(1. Jump to the Beginning of a Sheet)
您已滚动到Excel工作表的末尾,但想快速跳转到起点?按Control + Fn +左箭头键(Left arrow key)将带您到工作表中的第一行/列。
2. 跳到行首(2. Jump to the Beginning of a Row)
这类似于上面的快捷方式,但这个快捷方式将您带回连续的第一个单元格。假设(Say)您一直滚动到一行中的第 400 个单元格,按Fn +向左箭头键(Left arrow key)返回该行中的第一个单元格。
3. Jump to the Beginning of a Column/Line
按Command ( Cmd ) +向上箭头(Arrow Up)键可转到Excel中连续数据列中的第一个单元格。
4. 切换工作表(4. Switch Worksheets)
Excel 具有用于在工作簿中轻松导航多个工作表的(navigating multiple sheets in a workbook)快捷方式。按Option +向右键移动到(Right arrow key)Excel工作簿中的下一个工作表(向右) 。要移至上一个工作表(向左),请按Option +左箭头键(Left arrow key)。
格式化和编辑数据
这些键盘快捷键将促进Excel工作表中更快的数据输入和数据排列。
5.增加字体大小(5. Increase Font Size)
您是否眯着眼睛理解Excel工作表中的文本和数字?您绝对应该增加所有行和列的字体大小。
选择整个工作表 ( Command + A ) 并按Shift + Command + >(右(Right)尖括号键)以增加工作表的字体大小。
您还可以增加特定单元格、行或列的字体大小。只需(Simply)选择单元格、行或列,然后按Shift + Command + >。
6.减小字体大小(6. Decrease Font Size)
这与增加字体大小一样容易。选择要减小其字体大小的单元格、行或列,然后按Shift + Command + <(左尖括号键)。
7. 粗体、斜体和下划线文本(7. Bold, Italicize and Underline Text)
这些是Excel(Excel)和其他Microsoft工具中常用的文本格式属性。
选择要修改的单元格,然后按Command + B应用粗体格式。Command + I和Command + U将“斜体”和“下划线”格式应用到选定的列、行或单元格。
您还可以使用这些快捷方式撤消或删除应用于单元格的相应格式。
8.打开单元格格式对话框(8. Open Format Cells Dialog Box)
在“设置单元格格(Format Cells)式”对话框中,您可以访问用于数字、对齐方式、字体等的大量格式设置选项。假设(Say)您要更改 Excel 的日期格式或货币格式,您可以在“设置单元格格(Format Cells)式”对话框中执行此操作。
按Command + 1打开对话框。
9.隐藏或取消隐藏列(9. Hide or Unhide a Column)
选择(Select)要隐藏的列中的任何单元格,然后按Command + )(右括号键)。
这将隐藏列中的所有单元格。确保记下分配给要隐藏的列的字母。当您想取消隐藏它时,这将帮助您轻松定位列的位置。
您可以同时隐藏多个列。只需(Simply)在每列中选择一个单元格,然后使用上面的快捷方式来隐藏它们。
要取消隐藏或显示列,请选择隐藏列左侧和右侧的任何单元格,然后按Shift + Command + )。
10.隐藏或取消隐藏一行(10. Hide or Unhide a Row)
选择(Select)要隐藏的行中的任何单元格,然后按Command + ((左括号键)。
也可以同时隐藏工作表中的多行(multiple rows in your worksheet)。
要在工作表中恢复一行,请选择隐藏行左右位置的单元格,然后按Shift + Command + (。
11. 编辑单元格(11. Edit a Cell)
您还在Excel(Excel)中双击单元格来编辑其内容吗?按F2或使用Control + U热键是更快的选择。这些快捷方式激活“编辑模式”并将插入点/光标定位在行尾,以便您可以立即开始编辑。
12.插入超链接(12. Insert a Hyperlink)
按Command + K插入文本链接。Control + K是执行相同功能的备用键盘快捷键。
13. 开始新的生产线(13. Start a New Line)
在输入单元格时按Return/Enter将完成单元格输入。要在单元格中输入数据时开始换行,请按住Option键并按Return。
您也可以使用Control + Option + Return来实现相同的结果。
常用 Excel 快捷方式
本节中的一些热键是系统范围的键盘快捷键(system-wide keyboard shortcuts),可在Mac上的每个应用程序中使用。您可能已经每天都在使用它们,它们确实可以帮助您更快地完成工作。这就解释了为什么它们作为一些最好的Excel键盘快捷键在此列表中。
14.撤消更改(14. Undo Changes)
您是否(Did)在工作表中输入了无效或不正确的数据?或者,您只是想撤销最近执行的操作?在 Mac 键盘上敲击Command + Z或Ctrl + Z以撤消应用于工作表的最新操作。
15. 重做更改(15. Redo Changes)
要重新应用您在Excel(Excel)中撤消的最后一个操作或公式,请按Command + Y或Ctrl + Y。这将“重做”最近撤销的操作。
将“Control + Z”视为(从您的工作表中)取出垃圾,将Control + Y视为将其带回。
16.粘贴特殊元素(16. Paste Special Elements)
“Paste Special”功能在标准机盖粘贴功能不合适的情况下派上用场。
如果您经常在工作簿中粘贴特殊元素,请使用Control + Command + V快捷方式快速访问“选择性粘贴”(Paste Special)对话框。或者,按Control + Option + V或Command + Option + V。
17.选择整列或整行(17. Select Entire Column or Entire Row)
使用Control + Spacebar选择一列中的所有单元格,或使用Shift + Spacebar选择工作表上一行中的所有单元格。
18. 创建一个新工作簿(18. Create a New Workbook)
想要在打开 Excel 或处理其他工作簿时创建新工作簿?按键盘上的Command + N或Control + N完成。
这将立即打开一个带有空白工作表的新Excel窗口。(Excel)这比在 Mac 的菜单栏中选择Excel >文件(File)>新建要快得多。(New)
(Create Custom Keyboard Shortcuts)在Excel中(Excel)创建自定义键盘快捷键
Microsoft 允许用户根据其使用要求创建自定义键盘快捷键。(create custom keyboard shortcuts)因此,如果您没有找到满足您需求的快捷方式,请按照以下步骤创建一个。
- 打开 Excel,选择菜单栏上的工具,然后选择(Tools)自定义键盘。(Customize Keyboard.)
- 滚动(Scroll)“类别”列表并选择包含您要分配快捷方式的命令的选项卡。然后(Afterward),在“命令”列表中选择一个命令以继续。
假设(Say)您要为Autosum公式分配一个新的快捷方式,在“Categories”部分中选择“ Formulas ”选项卡,然后在“Commands”列表中选择Auto-sum 。如果命令已经有快捷方式,您将在“当前键”框中看到热键。否则,该框将为空白。
- 选择按下新键盘快捷键(Press new keyboard shortcut)对话框并按住要分配给所选命令的键。
快捷方式必须至少包含一个修饰键(Command、Shift、Option或Control)和任何其他键(字母、功能键、数字、方向键/箭头等)。
- 检查对话框下方的“当前分配给”结果,并确保它显示为Unassigned。如果组合键已分配给命令,自定义工具会显示当前使用热键的操作。
- 选择添加(Add)并选择确定(OK)以将快捷键分配给操作。
出色地使用键盘快捷键
您不可能一次记住这些快捷方式。可能需要几天或几周的时间才能熟悉这些键盘快捷键,具体取决于您使用它们的频率。我们建议您在浏览器中为这篇文章添加书签,以便您随时可以回来参考这些快捷方式。
也就是说,Excel有数百个键盘快捷键。如果您没有发现这些热键有用,您应该从 Microsoft 网站下载 Excel 快捷方式备忘单。(download the Excel Shortcuts Cheat Sheet)它是一个PDF文档,包含适用于Mac和Windows计算机的所有Excel 键盘(Excel keyboard)快捷键。在预览或任何 PDF 查看器中浏览文档并执行搜索以找到热键以在(Preview or any PDF viewer)Excel中执行操作或公式。
The 18 Best Excel Shortcuts for Mac Users
Keyboard shortcuts in Excel are designed to make your life easy. They shorten the time required to perform certain tasks, actions, and commands. If you own a Mac and you use Microsoft Excel in your everyday life, the shortcuts in this post can improve your productivity.
We highlight some of the best Excel shortcuts on your Mac for formatting data, editing data entry, navigating worksheets, managing files, etc. You’ll also find popular shortcuts frequently used by many Excel users.
As a cherry on top, we also included steps to create your own custom keyboard shortcuts in Excel.
Navigation Shortcuts
Moving around your worksheet or workbook in Excel can sometimes be difficult, especially if you’re working with a huge dataset. These shortcuts can make navigation easier and faster.
1. Jump to the Beginning of a Sheet
You’ve scrolled to the end of an Excel worksheet but want to quickly jump to the starting point? Pressing Control + Fn + Left arrow key will take you to the first row/column in the sheet.
2. Jump to the Beginning of a Row
This is similar to the shortcut above, but this one takes you back to the first cell in a row. Say you’ve scrolled all the way to the 400th cell in a row, press Fn + Left arrow key to go back to the first cell in that row.
3. Jump to the Beginning of a Column/Line
Press Command (Cmd) + Arrow Up key to go to the first cell in a column of contiguous data in Excel.
4. Switch Worksheets
Excel has shortcuts for easily navigating multiple sheets in a workbook. Press Option + Right arrow key to move to the next worksheet (to the right) in your Excel workbook. To move to a previous worksheet (to the left), press Option + Left arrow key.
Formatting and Editing Data
These keyboard shortcuts will foster quicker data entry and data arrangement in your Excel worksheet.
5. Increase Font Size
Do you squint your eyes to make sense of texts and digits in your Excel worksheet? You should definitely increase the font sizes of all rows and columns.
Select the entire worksheet (Command + A) and press Shift + Command + > (the Right angle bracket key) to increase the worksheet’s font size.
You can also increase the font size of a specific cell, row, or column. Simply select the cell, row, or column and press Shift + Command + >.
6. Decrease Font Size
This is equally as easy as increasing font sizes. Select the cells, rows, or column whose font sizes you want to reduce and press Shift + Command + < (the Left angle bracket key).
7. Bold, Italicize and Underline Text
These are commonly used text formatting attributes in Excel and other Microsoft tools.
Select the cell(s) you want to modify and press Command + B to apply the bold formatting. Command + I and Command + U will apply the “italic” and “underline” formatting to the selected column, rows, or cells.
You can also use these shortcuts to undo or remove the respective formatting you applied to a cell.
8. Open Format Cells Dialog Box
In the Format Cells dialog box, you get access to extensive formatting options for numbers, alignment, fonts, etc. Say you want to change Excel’s date format or currency format, you do so in the Format Cells dialog box.
Press Command + 1 to open the dialog box.
9. Hide or Unhide a Column
Select any cell in the column you want to hide and press Command + ) (the Right parenthesis key).
That’ll conceal all cells in the column. Make sure you take note of the letter assigned to the column you want to hide. That’ll help you easily locate the position of the column when you want to unhide it.
You can hide multiple columns at the same time. Simply select a cell in each column and use the shortcut above to hide them.
To unhide or reveal a column, select any cell to the left and right of the hidden column(s) and press Shift + Command + ).
10. Hide or Unhide a Row
Select any cell(s) in the row you want to hide and press Command + ( (the Left parenthesis key).
It’s also possible to hide multiple rows in your worksheet simultaneously.
To bring back a row to your worksheet, select cells to the right and left position of the hidden row and press Shift + Command + (.
11. Edit a Cell
Do you still double-click cells in Excel to edit their content? Pressing F2 or using the Control + U hotkey are faster alternatives. These shortcuts activate “edit mode” and position the insertion point/cursor at the end of the line so you can start editing instantly.
12. Insert a Hyperlink
Press Command + K to insert a link to a text. Control + K is an alternate keyboard shortcut that performs the same function.
13. Start a New Line
Pressing Return/Enter while typing in a cell will complete the cell entry. To start a new line when entering data in a cell, hold the Option key and press Return.
You can also use Control + Option + Return to achieve the same result.
Frequently Used Excel Shortcuts
Some hotkeys in this section are system-wide keyboard shortcuts that work in every app on your Mac. You probably already use them every day, and they sure help you get things done faster. That explains why they’re on this list as some of the best Excel keyboard shortcuts.
14. Undo Changes
Did you enter invalid or incorrect data in your worksheet? Or, you simply want to reverse a recently-executed action? Whack Command + Z or Ctrl + Z on your Mac’s keyboard to undo the most recent action applied to the worksheet.
15. Redo Changes
To reapply the last action or formula you undid in Excel, press Command + Y or Ctrl + Y. That will “redo” a recently-reversed action.
Think of “Control + Z” as taking the trash out (of your worksheet) and Control + Y as bringing it back in.
16. Paste Special Elements
The “Paste Special” feature comes in handy in situations where the standard canopy-paste functionality isn’t appropriate.
If you often paste special elements in your workbook, use the Control + Command + V shortcut to quickly access the Paste Special dialog box. Alternatively, press Control + Option + V or Command + Option + V.
17. Select Entire Column or Entire Row
Use Control + Spacebar to select all cells in a column or Shift + Spacebar to select all the cells in a row on your worksheet.
18. Create a New Workbook
Want to create a new workbook when you open Excel or while working on another workbook? Press Command + N or Control + N on your keyboard to get it done.
That’ll immediately open a new Excel window with a blank worksheet. It’s a lot faster than selecting Excel > File > New on your Mac’s menu bar.
Create Custom Keyboard Shortcuts in Excel
Microsoft lets users create custom keyboard shortcuts tailored to their usage requirements. So, if you don’t find a shortcut that meets your needs, follow the steps below to create one.
- Open Excel, select Tools on the menu bar, and select Customize Keyboard.
- Scroll through the “Categories” list and select the tab housing the command you want to assign a shortcut. Afterward, select a command in the “Commands” list to proceed.
Say you want to assign the Autosum formula a new shortcut, select Formulas Tab in the “Categories” section, and select Auto-sum in the “Commands” list. If the command already has a shortcut, you’ll see the hotkeys in the “Current keys” box. Otherwise, the box will be blank.
- Select the Press new keyboard shortcut dialog box and hold the keys you want to assign to the selected command.
The shortcut must contain at least one modifier key (Command, Shift, Option, or Control) and any other key (letters, function keys, numbers, directional keys/arrows, etc.).
- Check the “Currently assigned to” result below the dialog box and make sure it reads Unassigned. If the key combination is already assigned to a command, the customization tools show you what action currently uses the hotkey.
- Select Add and select OK to assign the shortcut keys to the action.
Use Keyboard Shortcuts Excel-lently
You can’t possibly memorize these shortcuts at a go. It may take days or weeks to get conservant with these keyboard shortcuts, depending on how often you use them. We recommend bookmarking this article in your browser so you can always come back to reference these shortcuts.
That said, Excel has hundreds of keyboard shortcuts. If you don’t find these hotkeys beneficial, you should download the Excel Shortcuts Cheat Sheet from Microsoft’s website. It’s a PDF document that contains all Excel keyboard shortcuts for Mac and Windows computers. Go through the document in Preview or any PDF viewer and perform a search to find the hotkey to execute an action or formula in Excel.