8/11/2023 0 Comments Shortcut for redo in excelCtrl Down Arrow moves the cursor down one carriage return/line break at a time. Ctrl Left Arrow does the same from right to left. In Word, Ctrl Right Arrow moves the cursor across the document one word and/or punctuation mark at a time. It also moves the cursor to the beginning of a line or formula inside a cell while in Edit Mode. Ctrl Home moves the cursor to cell A1. In Excel, Home moves the cursor at the current cell address (e.g., K19) to the beginning of that line or row. For example, if your cursor is on the ninth word of the third line, Home moves the cursor to the beginning of that line. Ctrl Home moves the cursor to the Home position-that is, the beginning of the document. In Word, Home moves the cursor to the beginning of the line or row of your cursor’s current location. The GoTo feature can take you to a specific cell address or specific page. Click to view full image. For the Ribbon commands, it’s Alt H-F-D-G (Home, Find, GoTo). It’s Ctrl G or F5, followed by a dialog box that opens for additional input-the same dialog boxes as the Ribbon shortcuts. The only Navigation command on the Ribbon menu is the GoTo feature, which means go to a specific cell address (formula, object, region, etc.) or go to a specific page (section, line, graphic, etc.). These keyboard shortcuts make it easier to get where you need to go. The bigger your document or spreadsheet is, the harder it is to move within it. You save constantly (or you should), which is why you’ll want to use these ribbon shortcuts for Save and Save As, plus Print and Print Preview. The Ribbon version is Alt F-P for both File, Print and Print Preview, because when you select Print, the Preview displays as well. For Print, it’s Ctrl P or Ctrl Shift-F12. Excel stores an undo history for the number of actions that you specified in step 7.Print is simple, but many users go straight to Print Preview as a final sanity check on margins and layout. 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 |