Monthly Archives: October 2015

Trick or Treat 2015

This is Halloween, This is Halloween… Last year, I showed you the trick to turn your screen upside down… This year, you learn the trick to display your spreadsheet from right to left. Advertisements

Rate this:

Posted in General | Tagged | Leave a comment

Get rid of the GETPIVOTDATA without disabling it

If you do Pivot Table, I believe you should have experienced the following too.   GETPIVOTDATA is good.  But sometimes we just want a simple cell reference.  We may disable the GETPIVOTDATA easily by going to Pivot Table Option –> Uncheck … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 2 Comments

F12 – It is for the things that matter

Why is F12 for the things that matter?  Because it basically performs one crucial action: SAVE. F12 alone – Save as (Alt+F2 does the same) Ctrl+F12 – Save as (same as F12 alone) Shift+F12 – Save (Ctrl+S does the same … Continue reading

Rate this:

Posted in Shortcut | Tagged | 1 Comment

F11 – it is for coding

F11 key should be the most-hit key for those who use Marco or VBA a lot in Excel.  If you use F11 but do not work with VBA at all, then you must have inserted new (blank / chart) sheet very … Continue reading

Rate this:

Posted in Shortcut | Tagged | 2 Comments

F10 – It is for showing the tips

Out of the following combinations for F10, I find one of them really useful.  Wanna guess which one? Let’s take a quick look at what F10 does: F10 alone – Shows the shortcut key for the commands on the Ribbon … Continue reading

Rate this:

Posted in Shortcut | Tagged | Leave a comment

F9 – it is for giving you “correct” answers

When you think your Excel is not calculating… Stay Calm and Press F9. I have to admit that I did not know about “Manual Calculation” mode in Excel long long time ago.  I still remember how stupid I was when … Continue reading

Rate this:

Posted in Shortcut | Tagged | Leave a comment

F8 – It is for selecting range(s) of cells

In the introductory post of Function Keys, I used F8 as an example to illustrate the situation when we thought we know English but cannot comprehend a sentence. F8: Turns extend mode on or off. In extend mode, Extended Selection appears in the … Continue reading

Rate this:

Posted in Shortcut | Tagged | 2 Comments

F7 – It is about word

If you do not spell very well and your boss pays attention to spelling, please make sure you  press F7 before sending your Excel reports.  Otherwise, your boss may challenge your spelling instead of your analysis. 🙂 F7 key is … Continue reading

Rate this:

Posted in Shortcut | Tagged | Leave a comment

F6 – It is for those who do not like Mickey…

If you never work with mouse for your Excel work, I believe your are a true master in using F6. If you use both mouse and keyboard like most people do,  you may probably know little about F6. However if one … Continue reading

Rate this:

Posted in Shortcut | Tagged | Leave a comment