Jo’s first keyboard shortcut
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?
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
Introducing our Online Power BI Class:
Would you like to join me on a date with Power BI? In this comprehensive online class, learn all about Power BI so you can create beautiful, insightful & interactive reports. Join me and rest of the play mates for our first ever Power BI Play Date.Click here to know more and join us.
Leave a Reply
|Start your bar charts from zero – Excel geeks screaming at you from mountain top||SUMPRODUCT Vs. Power Query on Mt. KauKau|