Category Archives: Shortcut

Keyboard shortcut tip – Filter by selection with Menu Key

Posted on April 25, 2015 by MF

You may have no idea about the shortcut key combinations above (the middle clip art is not a key combination, ok?!).  That’s normal, I guess.  Most of the time we talk about keyboard shortcuts, we think about Ctrl or Alt. … Continue reading →

Rate this:

Posted in Excel Tips, Shortcut | Tagged , , | 5 Comments

Do you know Menu Key??

Posted on April 18, 2015 by MF

This key is sitting on the keyboard forever.  I wonder how many people have ever pressed it?  Maybe you don’t even know where the key is on keyboard… do you? It is between “Windows” and “Ctrl”, just two keys below … Continue reading →

Rate this:

Posted in Excel Tips, Shortcut | Tagged | 2 Comments

Probably the fastest way to convert formula into value – CTRL C, CTRL V, CTRL, V

Posted on November 12, 2013 by MF

“Copy and Paste Value” is probably one of the most popular actions taken by many people every day.  A probably fastest way to do so is definitely worth sharing. I learn this from a comment to the post (http://www.myonlinetraininghub.com/favourite-excel-shortcuts) by MYNDA TREACY … Continue reading →

Rate this:

Posted in Excel Tips, Shortcut | Tagged , , , , | 6 Comments

Another use of F4 – Repeat LAST action

Posted on September 22, 2013 by MF

Excel tips: F4 to repeat LAST action As mentioned in my previous post, F4 is my favorite keyboard buddy.  It helps you quickly shift between relative reference and absolute reference when building formula; it also helps to repeat your last … Continue reading →

Rate this:

Posted in Excel Tips, Shortcut | Tagged | Leave a comment

How to switch between Absolute and Relative reference? F4

Posted on September 12, 2013 by MF

如何快速轉換公式中的絶對參照及相對參照? To kick off my first blog, I would like to introduce my buddy on keyboard to you – F4 To me, it helps 1)      Switch between Relative and Absolute reference easily when typing formula 2)      Repeat last action Let’s … Continue reading →

Rate this:

Posted in Excel Tips, Formula, Shortcut | Tagged | 1 Comment