To learn more about how torepeat the last action in Excel, read further. If you want to duplicate your actions (specifically related to formatting) without having to repeat them manually each time, you can use the‘Repeat’ commandor a simplekeyboard shortcut. Repeat the last action in Excel...
Another keyboard shortcut you can use to repeat the last action isControl + Y (in Windows)andCommand + Y (in Mac)To use this shortcut, you need to select the cells or range of cells where you want to repeat the last action, then hold the Control key, and then press the Y key....
1. General Keyboard ShortcutsActionsWindows Shortcut Open Help F1 Undo Last Action Ctrl + Z Redo Last Action Ctrl + Y Copy Selected Cells Ctrl + C Cut Selected Cells Ctrl + X Paste Content from Clipboard Ctrl + V Repeat last action F4 Display the Paste Special Dialog Box Ctrl + Alt +...
The shortcuts in this topic refer to the US keyboard layout. Keys for other layouts might not correspond exactly to the keys on a US keyboard. A plus sign (+) in a shortcut means that you need to press multiple keys at the same time. A comma sign (,) in a shortcut means that ...
To quickly apply borders to the selected cells, use the keyboard shortcut: ALT + H + B + A Note that this applies the “All Border” format, which means that all the cells get the border format. If you want to apply the Outline border only use ALT + H + B + S. ...
These shortcuts allow you to quickly apply number formats to a cell or range. You use the number keys above the letters on the keyboard to press the shortcuts. ShortcutWindowsMacWeb Apply General format to selected cells Ctrl+Shift+~ Ctrl+Shift+~ Apply Number format to selected cells Ct...
A good knowledge of keyboard shortcuts for Excel helps user work more efficiently. The Excel shortcut keys make us work 10 times faster than using the
Save time with Excel keyboard shortcuts and Excel productivity tips. Watch videos and get the shortcut list
Learn how to repeat the last action in Excel without going through all the steps again. Follow this guide to add the Repeat command to your Quick Access Toolbar or use the keyboard shortcut.
Move to the first cell in the upper-left corner of the sheet or selected table Ctrl+End Move to the last cell in the lower-right corner of the sheet or selected table Ctrl+Enter Fill typed value and press this keyboard shortcut to add your content in all selected cells ...