Tag Archives: Keyboard Shortcut

Replace blanks with zero in #Excel

Following the techniques used in the previous post , we can perform many Excel magics for different scenarios.  On top of my mind is to replace blank cells with zero.   The first task is to select all blank cells in … Continue reading

Rate this:

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

Delete rows with empty cell(s) in #Excel

Guess what?  We are going to do it with a sequence of keyboard shortcuts only.  Believe it or not, it requires only 8 key strokes: Ctrl+A => Ctrl+G => Alt+S => k => Enter => Ctrl+- (minus sign) => r … Continue reading

Rate this:

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

Insert Current Time or Today using #Excel functions or shortcuts

It’s not uncommon to insert a date stamp or time stamp on a spreadsheet.  We may use the following functions to get the results easily: =TODAY() ‘to get the date of today =NOW() ‘to get both the date of today … Continue reading

Rate this:

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

CTRL A to Z – Learn 25 #Excel Shortcuts with demonstrations

Do you know how many keyboard shortcuts we have in Excel?  Honestly, I don’t know.  I just know the shortcuts that I need to use.  Believe it or not, from Ctrl+ A to Z, I use them all but M, … Continue reading

Rate this:

Posted in Shortcut | Tagged | Leave a comment

Customize Alt 1 to 4 to become the favorite #Excel shortcuts of your own

When talking about keyboard shortcuts, there is always discussion on what’s the most time-saving shortcuts, what are the top X shortcuts you should learn, what is the most frequently used shortcuts, etc… Just to name a few, Ctrl+S to save, … Continue reading

Rate this:

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

Create your own favorite keyboard shortcuts in #Excel without VBA

Make better use of the Quick Access Toolbar (QAT) We all know that shortcuts could save us lots of time when working with Excel.  Excel has many built-in shortcuts.   Ctrl+C, Ctrl+V should be the most popular and commonly used … Continue reading

Rate this:

Posted in Shortcut | Tagged , | 3 Comments

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