How To Quickly Repeat Last Action In Word/Excel


Repeating Last Action

There is a key that is hardly used and yet is a highly efficient shortcut for speeding up tasks in Word and Excel when you need to repeat the same action, once, twice or many, many times!

That key is the F4 key!

In Word and Excel many tasks can be repeated instantly by tapping the F4 key for as many times as you would like to repeat your last action.

Say you would like to highlight something– do it once and then click F4 to repeat that action.

BONUS: This works not only in Word and Excel but in other Office applications as well!


BONUS BONUS: As you all know, I love to save time and keystrokes!  You can also achieve this by clicking CTRL + Y!

About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.

7 Comments

  1. Ctrl-PgDwn for sheet forward
    Ctrl-PgUp for sheet back

    Ctrl-tab for next workbook
    Ctrl-Shift-tab for previous workbook

    I hope this proves helpful to you!

    • Carol:
      Thanks for your 4 shortcut-keys, but I was looking for a shortcut-key that acts like a BACK button which would return me to the sheet (and the position within that sheet) I last edited (not just move me forward/backward to the next/previous sheet).
      Dan

  2. If you are looking for a single shortcut that will toggle between the two worksheets, then you can use a macro such as this, which was created by Allen Wyatt:

    Sub JumpBetween1()
    If ActiveSheet.Name = “Sheet1” Then
    Worksheets(“Sheet4”).Activate
    Else
    Worksheets(“Sheet1”).Activate
    End If
    End Sub

    The macro will check to see which worksheet is currently displayed. If it is Sheet1, then Sheet4 is displayed. In all other instances, Sheet1 is displayed. This is handy, but it means that if you currently have Sheet2 displayed, the shortcut will always display Sheet1. You might not want the macro to do anything unless either Sheet1 or Sheet4 is displayed. In that case, you should use this variation of the macro which Allen Wyatt also created:

    Sub JumpBetween2()
    If ActiveSheet.Name = “Sheet1” Then
    Sheets(“Sheet4”).Activate
    ElseIf ActiveSheet.Name = “Sheet4” Then
    Sheets(“Sheet1”).Activate
    End If
    End Sub

    Note that the only difference between the two macros is that the latter variation uses ElseIf to check if Sheet4 is displayed. This means that if any worksheets other than Sheet1 or Sheet4 is displayed, the macro will do nothing.

Leave a Reply

Your email address will not be published. Required fields are marked *