Undo, redo, and redo actions in Excel 2010

Source: Internet
Author: User

In Microsoft Office Excel, you can undo and redo up to 100 operations, even after you save the worksheet. You can also repeat any number of actions.

Undo the previous or multiple actions performed

To undo an action, do one or more of the following:

Click Undo on the Quick Access Toolbar

Keyboard shortcuts can also be pressed ctrl+z.

To undo multiple actions at the same time, click Undo

Arrow next to it, select the action you want to undo from the list, and then click the list. Excel undoes all the selected actions.

Before you press ENTER, you want to cancel the cell or formula bar Edit bar: The bar at the top of the Excel window for entering or editing values or formulas in a cell or chart. Constant values or formulas stored in the active cell are displayed in the formula bar. , press ESC.


Some actions cannot be undone, such as clicking any Microsoft Office button

command, or save the workbook. If the action cannot be undone, the Undo command becomes "cannot be undone."

Macros can clear all items in the Undo list.

Redo the Undo action

To redo the undo action, click Restore on the Quick Access Toolbar

Keyboard shortcuts can also be pressed ctrl+y.

Note the restore command changes to repeat when all undone actions are restored

Repeat previous action

To repeat the previous action, click Repeat on the Quick Access Toolbar.

Keyboard shortcuts can also be pressed ctrl+y.

Note Some operations cannot be duplicated, such as using functions in cells. If you cannot repeat the previous action, the repeat command changes to "cannot be repeated."

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.