![]() ![]() Keyboard shortcuts can save you heaps of time when working with Excel data. You can repeat your last action by either using the shortcuts – F4 or Ctrl + Y or by adding the Repeat Command on your Quick Access Toolbar. So, you can avoid typing the same text, formula, or formatting on each and every cell of the sheet. Repeat Command is now no longer part of the Quick Analysis Toolbar! STEP 3: Under Customize Quick Access Toolbar, select Repeat. You can remove this command from the QAT. You can now easily Redo the last action by simply clicking on it. STEP 4: Click on Add and then you will see Repeat added to the right. STEP 3: In the Excel Options dialog box, from the list of commands under Popular Commands select Repeat. STEP 2: Select More Commands from the list. STEP 1: Select the small arrow on the top of the ribbon to access the Quick Access Toolbar. ![]() To add Repeat Command in QAT, do as follows: ![]() Let’s try the repeat command to redo the last action in Excel!Īnother easy way is to add the Repeat command on the Quick Access Toolbar and simply click on it to repeat the last action multiple times. Instead of using a keyboard shortcut, you can even add the Repeat Command in your QAT! In the same manner, you can use the keyboard shortcut Ctrl + Y to get the task to repeat again!! Previously, you have used the shortcut F4 to redo a task in Excel. This is how you can repeat last action Excel. Perhaps this will clear confusion, but effectively CMD-Y seems to work as follows: IF there is something to Redo: perform Redo. STEP 3: To repeat this action, simply press F4. How about F4 alone This allows you to move to a new position in a document then simply repeat the last action you performed (e.g. VidarS.Ramdal CMD-Y is the redo command but also Repeat Last Action. STEP 1: Select the row above which you want to insert a blank row. If you want to insert blank rows multiple times using f4 keyboard shortcut, follow the steps below: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |