Trick or Treat 2014

Today is Halloween.  Let’s do some funny things today.

Excel Tips - Trick or Treat 2015 v1

Have you ever thought about to turn your screen upside down?  To do this, you just need to press CTRL + ALT +↓  

Story behind:

I found this trick accidentally long time ago: A colleague was sitting on my keyboard and suddenly the screen turned upside down.  All of us had no clue of what had happened.  By “replicating” what he did just before the spooky incident, we suspected that it was triggered by combination of key strokes…… after many & many trial-and-errors, we realized that the CTRL+ALT+ARROW key did the trick.

  • Try also CTRL+ATL+← / →  to see the effect.
  • To resume normal: CTRL+ALT+↑.

Although we managed to figure out the key combination, we still had no clues how his butt could do that after so many years. 🙂

Note: It works for Windows only, I guess (at least not working in Mac).  If it doesn’t work in your Windows, maybe you are running a very OLD Windows.  😛  (btw, not tested on Windows 8)

A similarly-evil trick In Excel: to turn the spreadsheet Leftside Right.

Follow the simple steps:

File–>Options–>Advanced–>Scroll down to Display

Excel Tips - Trick or Treat 2015 v2

Check Right-to-left –> OK –> Close the Excel –> Reopen Excel

Excel Tips - Trick or Treat 2015 v3

Happy Halloween!

Advertisement

About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in General and tagged . Bookmark the permalink.

2 Responses to Trick or Treat 2014

  1. Micky says:

    1) CTRL+ALT+ARROWS shortcut does work with certain Display card drivers (not all).
    2) Most Hebrew & Arabic speaking languages users prefer the Right-to-Left layout, therefore – in their eyes – using the Left-to-Right layout seems as an “Evil trick”.
    Micky

    Like

    • MF says:

      Hi Micky,
      Thanks for your comments.
      I really don’t know it’s related to the Display Card. ;p
      And finally, I realize why there is a Right-to-Left layout. Thank you so much!
      Cheers,

      Like

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.