Excel shortcuts

15 Excel Shortcuts for Repeating Your Last Action

If you're anything like me, you're always looking for ways to work smarter, not harder. That's why I'm excited to share with you these 15 Excel shortcuts for repeating your last action. By using these shortcuts, you can save yourself time and effort when working in Excel.

1. Ctrl + Y: This shortcut will repeat your last action, whether it's inserting a row, deleting a column, or anything else. Simply press Ctrl + Y to repeat your last action.

2. Ctrl + Shift + Y: This shortcut is similar to the first one, but it will also reverse your last action. So, if you inserted a row and then realized you wanted to delete it, you could use this shortcut to delete the row.

3. Ctrl + Z: This shortcut is the undo shortcut. So, if you make a mistake and want to undo your last action, simply press Ctrl + Z. You can also use this shortcut to undo multiple actions by pressing it multiple times.

4. Ctrl + Shift + Z: This shortcut is the redo shortcut. So, if you undo an action and then decide you want to do it after all, you can use this shortcut to redo it. You can also use this shortcut to redo multiple actions by pressing it multiple times.

5. Ctrl + A: This shortcut will select all of the cells in your worksheet. This can be handy if you want to apply formatting to all of the cells or if you want to delete all of the cells.

6. Ctrl + B: This shortcut will bold the selected cells. This is a quick way to apply formatting to your cells without having to open the Formatting menu.

7. Ctrl + I: This shortcut will italicize the selected cells. This is a quick way to apply formatting to your cells without having to open the Formatting menu.

8. Ctrl + U: This shortcut will underline the selected cells. This is a quick way to apply formatting to your cells without having to open the Formatting menu.

9. Ctrl + 5: This shortcut will strike through the selected cells. This is a quick way to apply formatting to your cells without having to open the Formatting menu.

10. Ctrl + 1: This shortcut will open the Format Cells dialog box. This is where you can change the number format, font, alignment, and other properties of the selected cells.

11. Ctrl + 2: This shortcut will bold the selected cells. This is a quick way to apply formatting to your cells without having to open the Format Cells dialog box.

12. Ctrl + 3: This shortcut will italicize the selected cells. This is a quick way to apply formatting to your cells without having to open the Format Cells dialog box.

13. Ctrl + 4: This shortcut will underline the selected cells. This is a quick way to apply formatting to your cells without having to open the Format Cells dialog box.

14. Ctrl + 6: This shortcut will strike through the selected cells. This is a quick way to apply formatting to your cells without having to open the Format Cells dialog box.

15. Ctrl + 7: This shortcut will open the Format Cells dialog box. This is where you can change the number format, font, alignment, and other properties of the selected cells.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.