Tag Archives: Keyboard Shortcut

Move cells with data to the top

Did you spend too much time to move cells so that there are no blank cells in each column? Again, a picture tells thousand words.  Here’s the task… Would you do it this way? Or this way? What did I do … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | 1 Comment

Open sesame with Alt+↓

Alt+↓ is absolutely one of my frequently used shortcuts when using Excel. What it does?  “Open sesame” under four common circumstances. 🙂 When you are at the bottom of a column   Alt+↓ displays the list of items on the column. … Continue reading

Rate this:

Posted in Shortcut | Tagged | Leave a comment

Page Right and Page Left… why no such keys?

As an Excel user, have you ever wondered why there are Page Up and Page Down keys on keyboard, but not Page Right and Page Left keys?  I do. You may probably know that you may navigate to the right … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | 2 Comments

Ctrl+A can be more convenient than you think of…

If you think Ctrl+A does merely Select All, then you are likely not using it frequently.  Let’s me take you through how to boost your efficiency working with Excel with Ctrl+A under different situations.

Rate this:

Posted in Excel Tips | Tagged | 6 Comments

When you forget to hold Ctrl key for inputting same value to a range…

… Ctrl+D or Ctrl+R is ready to help 🙂 Ctrl+Enter is one of my favorite shortcuts.  It helps me to input a value or a formula to a range simultaneously.  As usual, Ctrl+Enter won’t let me down.  But many times, … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

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

Delete every thing behind the insertion point – Ctrl Delete

The shortest post ever! 🙂

Rate this:

Posted in Excel Tips | Tagged | 3 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