Ctrl + Z in Excel: Functions and How to Use It - Compute Expert

Ctrl + Z in Excel: Functions and How to Use It


Home >> Excel Tutorials from Compute Expert >> Excel Tips and Trick >> Ctrl + Z in Excel: Functions and How to Use It





From this tutorial, you will learn the functions of and how to use Ctrl + Z in Excel.

When working in Excel, we can use many shortcuts to help us work faster. One of those shortcuts is Ctrl + Z. With this shortcut in place, we can fix the mistakes we do in Excel easily and get much better results from our work.

Want to know more about the Ctrl + Z shortcut and the way to use it properly in Excel? Let’s discuss it right away.

Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more

Want to work faster and easier in Excel? Install and use Excel add-ins! Read this article to know the best Excel add-ins to use according to us!

Learn Excel Dashboard Course






Functions of Ctrl + Z in Excel

We can use Ctrl + Z in Excel to undo the activities that we do in Excel.

We may need to use this shortcut often because we can have many instances when we do wrong data inputs or wrong data processing in Excel. Therefore, it can be important to get used to using it if you haven’t.



How to Use Ctrl + Z in Excel

To use Ctrl + Z to undo your activities in Excel, just press the Ctrl and Z buttons simultaneously on your keyboard. Excel will immediately cancel the result of your last activity in Excel after you do that.

The maximum number of activities in a sequence that Excel can undo is 16.



Ctrl + Z Alternative in Excel: The “Undo” Button

Besides using Ctrl + Z, you can also use the “Undo” command button to undo your activities in Excel.

The button is located on your quick access toolbar or the "Home" tab of your Excel ribbon.



Exercise

After you have known about the function of and how to use Ctrl + Z in Excel, let’s try it on your own.

Open an Excel file, do some activities in it, and try to undo them by pressing Ctrl and Z buttons on your keyboard. Can you do it?



Additional Note

  • In Mac, the similar shortcut to Ctrl + Z is Command + Z
  • You can increase the maximum number of activities you can undo in Excel by adding a relevant entry to your Microsoft Windows registry. However, if you do that, you shouldn’t increase it to more than 100 because that can make Excel takes too much memory from your laptop/PC RAM. This can make the performance of Excel and other applications you run with it much slower, especially if your laptop/PC has a small RAM capacity
  • To repeat the activities you have undone, you can use the Ctrl + Y shortcut




Excel tutorials you might want to read too:



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!





Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!




Learn Excel Dashboard Course

Follow our tutorial content also on


Excel Calculation

Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division in Excel

Average in Excel



Excel Formula

VLOOKUP Function in Excel

IF Function in Excel

SUM Function in Excel

COUNTIFS Function in Excel

SUMIFS Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text in Excel

Excel Worksheet Definition

Excel Range Definition

Excel Shortcuts



Excel Products & Services Recommendation

Best Laptops for Excel

Best Tablets for Excel

Best Keyboards for Excel

Best Mouse for Excel

Best Monitors for Excel



Excel Consultation

Recommended Things

About Us

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2024 Compute Expert