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, because no action is assigned to Ctrl+M yet.  Having said that, I am using M codes more and more recently.  Maybe Microsoft could assign Ctrl+M as Open the Power Query Editor to complete the list.  😛

Let’s talk about the shortcuts.  Maybe you already know most of them, but do you know ALL of them?  Especially the secret use of CTRL+J? Check it out! (02:07)

You can learn all the 25 shortcuts in a 7-minute video embedded in the end of this post.

Here’s a list for quick reference.  

CTRL + A Select All (00:11)

CTRL + B Toggle BOLD (font) (00:34)

CTRL + C Copy (00:42)

CTRL + D Fill Down (00:49)

CTRL + E Flash Fill (Excel 2013 or later) (00:59)

CTRL + F Find… (01:11)

CTRL + G Go To… (01:28)  

CTRL + H Find and Replace… (01:40)

CTRL + I Toggle Italic (font) (01:56)

CTRL + J Secret way to input line break (in Find and Replace) (02:07)

CTRL + K Insert Hyperlink (02:43)

CTRL + L Insert Excel Table (same as Ctrl + T) (03:01(why L? because Table was formerly known as List in Excel 2003)

CTRL + M Not assigned.

CTRL + N New Workbook (03:16)

CTRL + O Open (03:25)

CTRL + P Print (03:34)

CTRL + Q Quick Analysis (Excel 2016 or later) (03:42)

CTRL + R Fill Right (04:17)

CTRL + S Save (04:30)

CTRL + T Insert Excel Table (Same as Ctrl + L) (04:36)

CTRL + U Toggle underline (font) (04:48)

CTRL + V Paste (when something is cut/copied) (04:58)

CTRL + W Close current workbook (05:12)

CTRL + X Cut (05:20)

CTRL + Y Redo (Repeat last action) (05:30)

CTRL + Z Undo (06:11)

Watch the full video here:

 

EndNote:

Don’t try to memorize all the shortcut keys.  This is not a memory contest.  Instead of memorizing all the shortcut keys, we should think about what actions we performed most of the time, and then look for the shortcut keys for that actions.  Followed by using it until it becomes a habit, or even a reflex.  Think about Ctrl+C and Ctrl+V.  It’s so natural to use them in pair because we have been using it every day.  😛

Have you learnt some new shortcuts today?  What is your favorite shortcut?  Which shortcuts you use most?  Please share in comments.  🙂

Advertisements

About MF

An Excel nerd who doesn’t work on Excel most of the time at current job...... 🤔 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 Shortcut and tagged . Bookmark the permalink.

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 )

Google photo

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

Twitter picture

You are commenting using your Twitter 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.