Wouldnt it be better if you could spend a little less time navigating, formatting, and entering formulas for the data.

Wouldnt it be better if you could spend a little less time navigating, formatting, and entering formulas for the data Hence weve put together a list of keyboard shortcuts for Microsoft Excel.

I founded my own digital agency, Startup Cafe Digital, in 2015 where I help SMBs leverage social media, SEO, and content marketing to grow their traffic and generate qualified leads for their business.

The goal was simple: to arm other solopreneurs with all the right information and tools they needed to launch a successful online business.

If you purchase a product or service through one of these affiliate links, Ill receive a commission at no additional cost to you.

In most cases, youll find in-depth reviews, tutorials, and how-to guides of these tools on my blog to help you make informed decisions.

The repeat option can be used for other things, too, such as inserting and deleting columns and rows.

Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs.

The undo button in Excel reverts your worksheet to the state it was in just before you performed the most recent action.

Redo has the opposite effect, redoing what youve just undone, such as if you accidentally delete something.

Repeat lets you perform the same operation you completed on one cell, such as changing the font color, in additional cells.

Specific situations call for using undo, redo, and repeat.

Excel Padlock Icon Tabs How To Use It

Knowing which one to use, and how to use it, will help you work more quickly and automate tasks.

You can access the redo, repeat and undo buttons from the Excel menu, or you can use keyboard shortcuts.

Excels undo feature lets you quickly reverse previous actions.

Excel Padlock Icon Tabs Mac Users Can

Windows users can undo in Excel with the keyboard shortcut CtrlZ while Mac users can press CommandZ.

You can repeat these keyboard shortcuts more than once to undo more actions.

Another way to use the undo option in Excel is through the Quick Access Toolbar, which runs across the top of Excel spreadsheets.

The exact location of this icon will differ depending on which version of Excel youre using.

The maximum number of undo actions you can perform by default is 100.

Windows users can adjust the limit to a smaller number by tweaking the Windows Registry.

You can find the threshold stored in the UndoHistory value located in the HKCU hive, under SoftwareMicrosoftOffice Options.

You can perform a redo using the CtrlY keyboard shortcut in Windows or CommandY on a Mac.

Like the undo action, redo can be performed multiple times by using the same keyboard shortcut over and over.

The Quick Access Toolbar also has a Redo button right next to the undo button; its icon is an arrow pointing to the right.

For example, since you cant undo a worksheet deletion, redo cant make changes to worksheet tabs.

The repeat action in Excel utilizes the same shortcuts as redo ( CtrlY for Windows and CommandY for Mac).

Repeat lets you repeat the most recent thing you did in a different cell or cells.

Excel For Mac Padlock Icon Tabs