Canceling a Command

by Allen Wyatt
(last updated February 25, 2016)


If you start to perform a command or action within Excel, you may want to cancel it before it finishes. To do this, the general rule is to simply press the Esc key. This should cancel any command or action that Excel is processing. It is also interesting to note that you can press Esc to close most every dialog box that may pop up in Excel.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3319) applies to Microsoft Excel 97, 2000, 2002, and 2003.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...


Pulling All Fridays

It can be handy to know when specific weekdays occur within a range of dates. Figuring out this information, using ...

Discover More

Multi-Page Print Preview

Many users rely on Print Preview to show them what their printout will look like. When using Print Preview, you aren't ...

Discover More

Changing the Size of Start Screen Tiles

The Start screen can server as your launching pad for whatever programs you use on your system. If your Start screen ...

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

More ExcelTips (menu)

Automatic Recalculation Not Happening

Excel 97, under certain circumstances, has a problem recalculating worksheets reliably. This tip tells you how to patch ...

Discover More

Limiting Precision

There may be times you need to limit the amount of precision Excel uses in its calculations. Here is one way to ...

Discover More

Using the Same Range Name on Different Worksheets

Defined names can be a great boon when working in a worksheet. Usually names are available throughout an entire workbook, ...

Discover More

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.


If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 1 + 5?

2017-02-14 03:56:48


When running a command (e.g. Match or Vlookup) on a substantial amount of data, the UI simply freezes and Esc has no effect.

2016-09-27 01:03:11

Steve Shaw


This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.