sirtree.blogg.se

Next, we copy the formula from cell A1 and paste it into a specific range of cells from A1 to D10.

Next, we will use the redo shortcut to get the same data back that we have undone.įor this, we need to open an empty Excel sheet and insert some random value in cell A1 using the function RANDBETWEEN: First, we will perform some random actions in the Excel sheet and then undo them accordingly. Let us understand using the redo shortcut with the help of an example. If we often use a mouse, we can click on the redo shortcut directly from the quick access toolbar, and the corresponding actions will be performed. We can also press the F4 function key however, we first need to press the Fn or F-Lock key to activate the function keys. To redo something we have undone, we need to press the keyboard's shortcut key Ctrl + Y. But, it is important to note that the redo shortcut only works after we have undone or undo an action or multiple actions.

Using a redo shortcut is very easy in Excel. Once the REDO command is added in a right-hand side box, we must click on the OK button.Īfter clicking the OK button, the REDO command shortcut is added immediately on Quick Access Toolbar. Next, we must select the 'All Commands' option from the drop-down menu under the 'Choose commands from' section.Īfter getting the list of all commands, we need to locate the 'REDO' command and click on the 'Add >' button. We need to select the 'Quick Access Toolbar' from the left-hand side menu. In case the redo shortcut is not present on Quick Access Toolbar, we must add it manually by using the following steps:įirst, we need to navigate the File tab and select the 'Options' from the File menu list.Īfter selecting the 'Options', Excel displays the 'Excel Options' window. However, we can always add it on the quick access toolbar by going to Excel settings.Īdding a Redo Shortcut in Excel Quick Access Toolbar Sometimes, there may be cases when we don't see the redo shortcut on the quick access toolbar due to a change in Excel settings. The Excel redo shortcut on the quick access toolbar looks like the following image: Another benefit of the redo drop-down menu is that we can instantly select the desired action and return to that position. The redo shortcut on the quick access toolbar also includes a drop-down menu, which displays all the possible actions we can redo in a particular sheet. This shortcut is placed next to the undo shortcut by default. Redo Shortcut on Quick Access ToolbarĪnother shortcut to use the redo option in Excel is located on the quick access toolbar (QAT). This can prevent repeated use of redo shortcuts. In addition to this, we can also use the F4 function key to repeat the last action multiple times on Windows. Each time we press the redo shortcut keys, Excel will step forward or revert one undo action. That means we can use the shortcut to redo several possible actions. The redo keyboard shortcut allows multiple levels of redo actions. On MacOS, we must use the following keyboard shortcut to redo the last action: This is only applicable for Excel on Windows.

For the redo command, we need to press and hold the Ctrl key and then press the 'Y' key on the keyboard, i.e., Ctrl + Y. It also offers a quick keyboard shortcut key for the Redo command. Excel has a wide range of keyboard shortcut keys. One of the fastest methods to use most of the Excel actions is to use keyboard shortcuts. Let us now discuss both in detail: Redo Shortcut Keyboard Keys We can use any of the following Redo shortcuts in Excel: Excel allows two different ways or shortcuts to perform the redo action within our Excel sheet quickly. MS Excel has an extensive range of shortcuts for most of the basic and advanced tasks. This will help us revert the action we perform using the undo. In this article, we discuss the ways to access Redo shortcuts in Excel. The best advantage of undo and redo options in Excel is that we can immediately use them by shortcuts. If we recognize that there was no need to undo the action, we can cancel the undo by using the 'Redo' in Excel. Besides, the 'Redo' option is just the opposite of the 'Undo' option. However, we can easily rectify the mistakes if they have occurred due to any action performed in the last step. Since Excel allows us to work with large data, there may be cases when we make mistakes. The Undo and Redo are the two most common options or commands in MS Excel.