Jo, my lovely wife quit her job as my partner in crime at Chandoo.org recently and took up a lucrative position at NZ govt. agency. The other day I asked her “how was your day?” when she got home. She smiled and said, “I learned my first Excel shortcut!”.
Guess what it is?
F4.
That is right. The mighty F4 key. You can use it to repeat any action.
Jo was using it to insert rows in her workbook. After inserting first row (using CTRL+ of course), she would press F4 to add more rows as needed.
So next time you find yourself doing the same thing several times, use F4 and save yourself a few keystrokes or mouse moves.
Your mission: What is your partner’s shortcut of the moment?
Take a short break from work. Call / message / ask your partner (or friend, mate, parent or kid) what their shortcut of the moment is? Post it here in the comments section.
What… they don’t use Excel much? May be they should.
More reading: Complete list of Excel shortcuts
