Advertisements

In Microsoft Office, you can repeat your previous action performed using the F4 key on the keyboard. The computer remembers your previous action and this can be repeated using F4.

F4 key in keyboard

For example say you have drawn a table using the tools menu in word and you need to repeat the same table in another page or another word document. This time you need not got to the menu, just click on the place where you need to table and press F4, done you have the new table. Note that computer remembers the last action and in between you do any other action, it will repeat the last action.

This tip is helpful when you are doing lots of formating in Word or Excel sheets. Hope you enjoyed reading this tip.


19 Responses to “MS Office Tip: Repeat Previous Action using F4”

  1. yep that was a nice simple tip like the ctrl+Z to undo…

  2. nirmaltv says:

    @Rajesh,
    This is really useful if you are doing lot of formatting with Word or Excel.

  3. Vaibhav says:

    nice find nirmal, even i was not aware of it, never ever heard of it before. But, it was not working flawlessly on office 07, some of the functions or commands were not responding, but mostly did. :wink:

  4. nirmaltv says:

    @Vaibhav,
    I think some commands may not work in Office 2007, but will work in 2003. I have tested few and was successful.

  5. TipsoSaurus says:

    awesome tips Nirmal!
    Sweet and simple tips always help and this one will surely :)

  6. K-IntheHouse says:

    Nice tip buddy! I think every application should have a shortcut ‘?’ that will show us all the other shortcuts! :wink:

  7. kanak says:

    Great tip nirmal , I didnt know about this. I still wonder such kind of productive tips are still like a secret. I think microsoft should really do something to educate the users :) :D

  8. Nice tip Nirmal. I hardly know and use these shortcuts. Will try to remember it now

  9. ram says:

    nice tip buddy, i use shortcuts but never knew this

  10. [...] Group similar programs in start menu. 2. MS Office Tip : Repeat previous action using F4. 3. Edit YouTube videos. 4. Listen WikiPedia articles instead of reading them. 5. Make use of your [...]

  11. Jalaj says:

    I use it frequently for inserting or deleting rows in Excel whenever they are more time saving than traditional approach of selecting the number of row and inserting or deleting.

  12. nirmaltv says:

    @Jalaj,
    Good to see that some one is already using this tip. :smile:

  13. Manas says:

    Nice tip Nirmal. This is a real time-saver. :)

  14. Ashish Mohta says:

    pretty cool Nirmal. never knew about it.

  15. [...] shares a cool trick by which you can repeat your previous action performed using the F4 key on the keyboard. I really liked this post and will save a lot of time when I get into office and [...]

  16. Ashfame says:

    Cool find buddy. Stumbled to share the love. :wink:

  17. Alex says:

    Good trip, but it doesn’t work in Office 07 :sad: , someone knows more?

  18. Cheryl says:

    In Excel 2003, I used to always use the F4 key to repeat a sort I had made in another worksheet. This repeat previous action function does not work when it comes to sorting in Excel 2007. Do you have any tips or tricks on how to get it to work? Do you know if this is how it was meant to be?

  19. Cath Gillespie says:

    Cheryl – I haven’t checked, but by default the F4 function key in Excel is for absolute cell addressing – CTRL-Y is the repeat key in Excel – try that.

Leave a Reply