If you are using Microsoft Excel in your daily life, you can use excel shortcuts to save time. You may need to repeatedly do same operation while creating an Excel worksheet or word document .
How To Repeat The Last Action In Excel?
If you want to repeat action in Excel, like inserting a column/row, formatting cells, copy & pasting, etc, then you can use the keyboard shortcut F4 which will repeat your last action (in most cases).
Also, You can add the Repeat command button into the Quick Access Toolbar for easily repeating the last action by clicking on it directly. Please do as follows.
1. Click the Customize Quick Access Toolbar button (the down arrow). Then click More Commands from the drop-down list. See screenshot:
From the list of options provided on the “More Commands” tab, click on “Repeat” and add it to the Quick Access toolbar.
Now the Repeat command button is added into the Quick Access Toolbar. The Repeat command can be used as many times as required to repeat a previous action and repeat the command entered on one cell on the other cells.
How To Repeat The Last Action In Word?
You want to emphasize text in a document by formatting it as bold, with italics, and a larger font size or if you changed the font of a selected text and want to change another portion of text to the same font highlight other text and press F4.
For example, Choose “Bold Italic” and the desired font size. The selected text is formatted as bold, with italics, and a different font size.
Select the next word where this same format should be repeated.
Press [F4] or [FN+F4] . The formatting action is repeated.
Recommended For You
How To Print Only A Selected Area Of An Excel Spreadsheet
How to Working with Currencies in Excel
How to Fix a Missing Excel or Word icon on the Desktop
How to Access the Developer Tab in Excel
Published on: Feb 27, 2021-Last edited: 08-09-2023