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
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Start your bar charts from zero – Excel geeks screaming at you from mountain top
|SUMPRODUCT Vs. Power Query on Mt. KauKau »