You can do this for the last 100 actions made. If you'd like to continue undoing actions, you can keep using the keyboard shortcut until you reach your desired change. This can allow you to undo the last action made. On a PC, you could press the "Control" and "Z" keys. On a Mac computer, you could press the "Command" and "Z" keys. Keyboard shortcutĪ quick way to undo an action in Excel is to use a keyboard shortcut. Here are five ways you can undo an action in Excel: 1. Related: Basic Excel Formulas and How To Use Them How to undo in Excel This can save time and effort by quickly eliminating errors and their effects. Instead of manually deleting an unwanted addition or recreating a lost piece of content, undoing an action can revert the spreadsheet back to the state it was in before the mistake occurred. For example, you may have inserted an unwanted image that affected the formatting of the document or unintentionally deleted an important sentence. You can undo an action in Excel when you make a small error and would like to remove it quickly without affecting the format of the rest of the spreadsheet. Related: 26 of the Best Excel Tips To Optimize Your Use When is it important to undo in Excel? In this article, we describe how to undo in Excel using various methods and offer tips to help you create successful and error-free documents for personal or business use. Understanding how to undo an action in Excel can help you manage your spreadsheet creation process and limit the effects of small errors. As users implement and format their data, they may make mistakes or small errors that can affect the overall appearance, content or format of their sheet. Excel stores an undo history for the number of actions that you specified in step 7.Microsoft Excel can let users create online spreadsheets using relevant data. Type a value in the Value box, click OK, and then exit Registry Editor. In the Edit DWORD Value dialog box, click Decimal under Base. Select New Value #1, type UndoHistory, and then press ENTER. On the Edit menu, point to New, and then click DWORD Value. In Registry Editor, expand one of the following registry subkeys, as appropriate for the version of Excel that you are running:Įxcel 2007: HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\OptionsĮxcel 2010: HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\OptionsĮxcel 2013: HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Excel\OptionsĮxcel 2016: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options In the search box or the Run window, type regedit and press Enter.ĭepending on your version of Windows, you may be asked to confirm that you want to open Registry Editor. In Windows XP, click the Start button, and then click Run. In Windows 7 or Windows Vista, click Start. In Windows 10 or Windows 8, right-click the Start button and click Run. The following procedure uses the Registry Editor to change the number of undo levels for Excel, although you can do the same in Word or PowerPoint.Ĭlose any Office programs that are running. Warning: Increasing the number of undo levels should be done with caution and moderation: the more you increase the number of undo levels, the more random access memory (RAM) Excel requires to store the undo history, which affects the performance of Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |