Category Archives: Shortcut

Keyboard shortcut tip – Filter by selection with Menu Key

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??

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

“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 , , , , | 5 Comments

Another use of F4 – Repeat LAST action

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

如何快速轉換公式中的絶對參照及相對參照? 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