Tag Archives: Keyboard Shortcut

The modern way to shortcut in #Excel 365

Posted on February 12, 2023 by MF

We all know that shortcut keys boost productivity in Excel as we can perform certain actions quickly with just a few keystrokes… if we can memorize the shortcut key combinations. Be frank, how many shortcut keys do you remember? Normally, … Continue reading →

Rate this:

Posted in Excel 365 | Tagged | Leave a comment

Replace blanks with zero in #Excel

Posted on May 2, 2020 by MF

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

Posted on April 26, 2020 by MF

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

Posted on December 22, 2019 by MF

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

Posted on August 31, 2019 by MF

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

Posted on December 8, 2018 by MF

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

Posted on May 24, 2018 by MF

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

Posted on September 3, 2016 by MF

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+↓

Posted on June 4, 2016 by MF

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?

Posted on April 23, 2016 by MF

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 , | 4 Comments

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

Posted on July 18, 2015 by MF

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…

Posted on June 6, 2015 by MF

… 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

Posted on April 25, 2015 by MF

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

Posted on April 18, 2015 by MF

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

Posted on March 7, 2015 by MF

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

Posted on November 12, 2013 by MF

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