由于您可能在Excel(Excel)电子表格中执行大量操作，因此您肯定会犯错误或需要快速快捷方式。使用“撤消”(Undo)、“重做(Redo)”和“重复”(Repeat)，您可以快速反转、重做或多次重复同一操作。
如果您是Microsoft Excel(Microsoft Excel)新手或尚未执行这些操作，我们将向您展示如何在Excel中撤消以及如何在Windows、Mac和 Web 上重做和重复操作。
如何撤消 Excel 中的操作
撤消(Undo)是您可以执行的最常见操作之一。无论(Whether)您是错误地做了某件事还是很快改变了主意，您都可以轻松地撤消刚刚在Excel中所做的操作。
(Excel)Windows、Mac和 Web上的Excel均具有“撤消”(Undo)按钮，该按钮是一个指向左侧的圆形箭头。您可以在Windows(Windows)和Mac上的快速访问工具栏(Quick Access Toolbar)以及Excel 网页版的(Excel on the web)“主页”(Home)选项卡中找到它。
使用“撤消”(Undo)按钮撤消上一次操作。
在Windows和Mac上，您可以使用(Mac)“撤消”(Undo)按钮旁边的箭头来撤消之前的多个操作。在网络上，只需重复选择“撤消”(Undo)按钮即可撤消其他操作。
除了使用“撤消”(Undo)命令之外，您还可以使用键盘快捷键(use a keyboard shortcut)快速撤消上一个操作。Select Ctrl + ZWindows上的Ctrl + Z或Mac上的Command + Z来撤消操作。
注意：有些操作可能无法在Excel中(Excel)撤消(Undo)，例如保存文件。在这些情况下，“撤消”(Undo)图标将变灰，并且工具提示将显示为“无法撤消(Undo)”。
如何重做 Excel 中的操作
Excel中与“撤消”(Undo)一起使用的还有“重做”(Redo)命令。如果在使用撤消(Undo)操作后想要重做(Redo)，也可以使用按钮或键盘快捷键。
在Windows和Mac上，选择“快速访问工具栏”中的(Quick Access Toolbar)“重做”(Redo)按钮，该按钮是一个指向右侧的圆形箭头。
您可以使用“重做”(Redo)按钮旁边的箭头来重做多个操作。
在 Web 上，选择“主页”(Home)选项卡上的“重做”(Redo)按钮。如果您使用的是单行功能区(Single Line Ribbon)，则需要选择“撤消”(Undo)旁边的箭头，然后选择“重做”(Redo)，如下所示。要在网络上再次重复执行这些操作，只需多次
选择“重做”按钮即可。(Redo)
如果您更喜欢使用键盘快捷键(use a keyboard shortcut)，请在Windows上选择(Windows)Ctrl + Y，在Mac上选择(Mac)Command + Y。
注意：除非您先使用“撤消”，否则您不会看到可用的“重做”(Redo)按钮。
如何在 Excel 中重复操作
您会发现Excel(Excel)中另一项方便的操作是“重复”(Repeat)命令。这允许您多次执行相同的操作，例如重复粘贴相同的项目或应用相同的格式。您可能看不到“撤消”(Undo)和“重做”(Redo)等“重复”(Repeat)按钮，必须先启用它。
重复操作当前在Excel的(Repeat)Web 版本中不可用。
启用重复按钮
在Windows上，您需要将该按钮添加到快速访问工具栏(Quick Access Toolbar)，因为默认情况下该按钮不存在。
- 选择工具栏右侧的下拉箭头，然后选择“更多命令”，或转到“File > Options，然后选择左侧的
“快速访问工具栏” 。(Quick Access Toolbar)
- 在右侧第一个列表中，选择“重复”(Repeat)。然后，使用中心的添加(Add)按钮将操作移动到右侧的
快速访问工具栏列表。(Quick Access Toolbar)
- 使用(Use OK)底部的“确定”保存更改。当您返回工作表时，
您应该会看到“重复”按钮。(Repeat)
在Mac上，您可能在快速访问工具栏中(Quick Access Toolbar)看不到“重复”(Repeat)按钮，但可以轻松启用它。选择工具栏右侧的三个点，然后在列表中选择“重复”以在其旁边放置复选标记。(Repeat)然后您会看到它显示在工具栏中。
使用重复动作
在任一平台上，当您执行的操作可以重复时，您都会看到可用的“重复”按钮。(Repeat)它显示为指向右侧的圆形箭头。只需(Simply)选择“重复”(Repeat)按钮一次或多次即可。
与此列表中的其他操作一样，您可以使用快捷键组合而不是“重复”(Repeat)按钮。使用与“重复”(Repeat)相同的快捷方式“重做”(Redo)。在Windows(Windows)上，使用Ctrl + Y；在Mac上，使用Command + Y。
使用Excel中的“撤消”(Undo)、“重做(Redo)”和“重复”(Repeat)，您可以快速轻松地处理最近的操作。有关相关教程，请了解如何在 Excel 中录制宏(how to record a macro in Excel)以加快您一次又一次执行的任务。
How to Undo, Redo, and Repeat Actions in Excel
With the number of actions you are likely to perform in your Excel spreadsheets, you’re bound to make mistakes or need a quick shortcut. Using Undo, Redo, and Repeat, you can quickly reverse an action, redo it, or repeat the same action more than oncе.
If you’re new to Microsoft Excel or haven’t performed these actions yet, we’ll show you how to undo in Excel as well as redo and repeat a couple of different ways on Windows, Mac, and the web.
How to Undo Actions in Excel
Undo is one of the most common actions you can perform. Whether you do something by mistake or quickly change your mind, you can easily undo what you just did in Excel.
Excel on Windows, Mac, and the web each have the Undo button which is a rounded arrow pointing left. You’ll find it in the Quick Access Toolbar on Windows and Mac and on the Home tab in Excel on the web.
Use the Undo button to reverse your last action.
On Windows and Mac, you can use the arrow next to the Undo button to reverse several previous actions. On the web, simply select the Undo button repeatedly to reverse additional actions.
Along with using the Undo command, you can use a keyboard shortcut to quickly reverse the last action. Select Ctrl + Z on Windows or Command + Z on Mac to undo an action.
Note: There may be some actions that you cannot Undo in Excel, for example, saving a file. In these cases, the Undo icon will be grayed out and the tool tip will display as “Can’t Undo.”
How to Redo Actions in Excel
Along with Undo in Excel is the Redo command. If after you use the Undo action you want to Redo it, you can use a button or keyboard shortcut as well.
On Windows and Mac, select the Redo button, which is a rounded arrow pointing right, in the Quick Access Toolbar.
You can use the arrow next to the Redo button to redo several actions.
On the web, select the Redo button on the Home tab. If you’re using the Single Line Ribbon, you’ll need to select the arrow next to Undo and choose Redo as shown below. To repeatedly perform the actions again on the web, simply select the Redo button multiple times.
If you prefer to use a keyboard shortcut, select Ctrl + Y on Windows or Command + Y on Mac.
Note: You won’t see the Redo button available unless you use Undo first.
How to Repeat Actions in Excel
One more action you’ll find handy in Excel is the Repeat command. This allows you to perform the same action more than once such as pasting the same items repeatedly or applying identical formatting. You may not see the Repeat button like Undo and Redo and must enable it first.
The Repeat action is not currently available in the web version of Excel.
Enable the Repeat Button
On Windows, you’ll need to add the button to the Quick Access Toolbar as it’s not there by default.
- Select the drop-down arrow to the right of the toolbar and pick More Commands or go to File > Options and choose Quick Access Toolbar on the left.
- In the first list to the right, select Repeat. Then, use the Add button in the center to move the action to the Quick Access Toolbar list on the right.
- Use OK at the bottom to save the change. You should then see the Repeat button when you return to your worksheet.
On Mac, you may not see the Repeat button in the Quick Access Toolbar but can enable it easily. Select the three dots to the right of the toolbar and pick Repeat in the list to place a checkmark next to it. You’ll then see it display in the toolbar.
Use the Repeat Action
On either platform, you’ll see the Repeat button available when an action you perform can be repeated. It appears as a circular arrow pointing right. Simply select the Repeat button one or more times.
Like the other actions on this list, you can use a shortcut key combination instead of the Repeat button. Use the same shortcut to Repeat as Redo. On Windows, use Ctrl + Y and on Mac, use Command + Y.
Using Undo, Redo, and Repeat in Excel, you can quickly and easily take care of your most recent actions. For a related tutorial, look at how to record a macro in Excel to speed up tasks you perform again and again.
