fbpx
Search
Close this search box.

CP012: Top 10 Excel Keyboard Shortcuts for you

Share

Facebook
Twitter
LinkedIn

In the 12th session of Chandoo.org podcast, lets get productive fast.

CP012: Top 10 Excel Keyboard Shortcuts for your productivity & success

Announcement: Short format podcasts sessions once a month

Based on your feedback, I am adding short format sessions (20 mins). These short format sessions will run once a month (along with longer sessions that we publish almost every week) so that you have something light & easy to chew between heavy doses of Excel awesomeness.

I hope you like this new format. Do let me know what you think in comments.

And I really appreciate your reviews & comments on iTunes. Please click here and post your review.

What is in this session?

Keyboard shortcuts are the low hanging fruits you must pluck in your journey to of Excel awesomeland. Just by learning a few handful shortcuts, you can save tons of time, work faster and create lasting impact. Not just that, learning something new (like shortcuts) can make you smart & sexy (as they as in Big Bang Theory, Smart is the new Sexy).

In this podcast, you will learn,

  • Announcement about the short format podcast sessions
  • 20 minute rule
  • Top 10 keyboard shortcuts (according to me)
  • ALT Key
  • CTRL + 1
  • ALT + ESV (or Menu Key + V)
  • Function key shortcuts (F2, F3 & F4)
  • & More

Go ahead and listen to the show

 

Links & Resources mentioned in this session:

20 minute rule

The 20 minute rule from time.com

Important Keyboard Shortcuts

Transcript of this session:

Download this podcast transcript [PDF].

What are your favorite Excel keyboard shortcuts?

Go ahead and tell us in comments. I am hoping to learn a few more useful ones.

Subscribe to Chandoo.org Podcast

Other options to subscribe

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Weighted Average in Excel with Percentage Weights

Weighted Average in Excel [Formulas]

Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel’s SUMPRODUCT formula to calculate weighted average / weighted mean.

What is weighted average?

Wikipedia defines weighted average as, “The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.”

Calculating weighted averages in excel is not straight forward as there is no built-in formula. But we can use SUMPRODUCT formula to easily calculate them. Read on to find out how.

16 Responses to “CP012: Top 10 Excel Keyboard Shortcuts for you”

  1. Hugh Parry says:

    Helpful stuff, thanks. It was a long time before I found out about the F9 "shortcut" which shows the partial result/evaluation of a selected part of a formula. It's great for debugging complex/array formulas.

  2. Jeffrey Lebowski says:

    Great podcast! I think Excel efficiency is vital for those who work with it a lot.

    I began my quest for Excel Awesomeness over three years ago, while taking a class at a university that was entirely in Excel. One of the points my teacher strongly emphasized greatly was to always try to use the keyboard instead of the mouse.

    Going from keyboard to mouse and vice versa is slow and cumbersone. If we can lose our dependency on the mouse, we can become very efficient in our computing, as this goes beyond Excel. (I like using Alt + Tab to navigate between open windows and Ctrl + Tab to navigate between internet tabs). I have really tried to honor this principle over the last several years.

    Two shortcuts that I heavily use are Ctrl + PgUp/PgDn to navigate between worksheets and Ctrl + Tab to navigate between Excel instances.

  3. Wesley Marshall says:

    Ctrl+Home/End to navigate to first and last cell populated in a sheet are very useful.

  4. Kiev says:

    Thank you Chandoo for this simple but useful podcast, my most frequently used ones are,

    Menu Key + S
    F4

    But just learned from you about Ctrl + shift + L for filter (although I prefer to add the quick access bar at the top of my excel.)

    Ctrl+shift+arrow key also is useful for grouping /ungrouping. Thanks.

  5. Don says:

    Thanks for the update .... I hadn't used the Menu key before.

    You only covered part of the F4 capability. The F4 key will repeat the last command (most commands, but not all) including repeating a macro, repeating formatting to a different cell or selection, inserting and deleting ....

  6. Venky says:

    Even F8 can be useful shortcut.

    For eg if you want to find totals of selected rows from a list of rows ( say from row 1 to 100 , i need to find sum for rows 1-5,16-19,21 we normally higlight 1-5 and click control and select the subsequent rows. we can use F8 for this. select 1-5 press F8 & SHIFT F8 the first block is selected, repeat this for other blocks.

  7. sabukajm says:

    Chandoo,
    You mentioned ALT + ESV shortcut. This works perfectly, but only in English version of Excel 😉
    Recently I found "real" shortcut for launching Paste Special window - Ctrl + Alt + V. Then, for pasting values, V again.
    And another one for the same action (it works for sure in Excel 2010 and 2013) - Ctrl + V and Ctrl + V again. Second Ctrl launches Paste Options button and second V stands for values.
    Waiting for coming short sessions! Thank you!

  8. slpete42 says:

    Short format and basics-like-this very agreeable for me. Another gift-burst of innovation. On target. Congrats.

  9. Oxidised says:

    Ctrl+1 is new to me and so very timely when I needed to build a dash board with lots of charts to format for work this week... so much faster!
    I think I ne most of the others, but I think I will try using Ctrl+Alt+V instead of Alt+ESV, just feels easier.

    I think keyboard short cuts make you heaps faster with excel, and it certainly is a good way to make others believe you know lots about excel 😉

  10. Scott says:

    CTRL + SHIFT + (An Arrow Key) to select all data in a row/column

    CTRL + Enter (with formulas) to quickly fill selected cells with that formula and calculate result. (special thanks to excelisfun for that shortcut)

    F9 to troubleshoot/evaluate formulas.

    These are my Big 3 shortcuts I use most often.

  11. Monu Alagh says:

    Yesterday i join the job and my boss give me a work on excel.And after searching excel keyboard shortcuts i jump to your site...Really helpful article...

    Thanks for the shortcut keys...

  12. […] History I thought of this on my way to work this morning when I (finally) started listening to Chandoo’s shortcut podcast. […]

  13. Sal says:

    Hi. It would be so much easier if you had a Youtube channel to show or explain what you are trying to teach instead of listening to Podcasts with no visuals. Just my 1 cent.

  14. Sal says:

    Also you go off topic....it would be better if you go straight to the point/topic...keep intro less than 45 secs...then go to the shortcuts.

Leave a Reply