{"id":7787,"date":"2015-10-05T19:04:08","date_gmt":"2015-10-05T17:04:08","guid":{"rendered":"\/\/www.myexcelonline.com\/podcast\/?p=588"},"modified":"2024-05-08T09:16:10","modified_gmt":"2024-05-08T07:16:10","slug":"005-my-top-10-excel-keyboard-shortcuts-excel-podcast","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/005-my-top-10-excel-keyboard-shortcuts-excel-podcast\/","title":{"rendered":"005: My Top 10 Excel Keyboard Shortcuts"},"content":{"rendered":"<div class=\"smart-track-player-container stp-color-f77223-EEEEEE spp-stp-desktop\" data-uid=\"32f1e921\"><\/div><div class=\"spp-shsp-form spp-shsp-form-32f1e921\"><\/div>\n<p><a href=\"\/\/traffic.libsyn.com\/myexcelonline\/005_My_Top_10_Excel_Keyboard_Shortcuts.mp3\" target=\"_blank\" rel=\"noopener\">Listen on Web Browser &gt;&gt;<\/a><\/p>\n<p>Excel Keyboard <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/\" target=\"_blank\" rel=\"noopener\" title=\"shortcuts\" data-wpil-keyword-link=\"linked\">shortcuts<\/a> are used by almost every one of the 750 million Microsoft Excel users worldwide.\u00a0 They range from the CTRL combinations shortcuts to the Function keys shortcuts as well as many other Excel keyboard shortcuts.<\/p>\n<p>In this episode I go through my top 10 favorite <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/mac-strikethrough\/\" target=\"_blank\" rel=\"noopener\">Excel keyboard shortcuts<\/a> that will save you heaps of time when working with Excel data.<\/p>\n<p><strong>What is your favorite Excel keyboard <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/\" target=\"_blank\" rel=\"noopener\" title=\"shortcut\" data-wpil-keyword-link=\"linked\">shortcut<\/a>?<\/strong>\u00a0 Let me know by entering it in the comments section of this episode at the bottom of this page.\u00a0 In a future Excel podcast episode I will publish the top 10 Excel keyboard shortcuts that are left in the comments section.<\/p>\n<p><em>You can subscribe to the show on\u00a0<strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/itune\" target=\"_blank\" rel=\"noopener\">iTunes<\/a><\/strong>\u00a0to get automatic\u00a0updates so you don&#8217;t miss out on these awesome interviews and Excel insights!<br \/>\n<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/005-my-top-10-excel-keyboard-shortcuts-excel-podcast\/#Top_10_Excel_Keyboard_Shortcuts\" title=\"Top 10 Excel Keyboard Shortcuts\n\">Top 10 Excel Keyboard Shortcuts\n<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/005-my-top-10-excel-keyboard-shortcuts-excel-podcast\/#Interview_Links\" title=\"Interview Links\n\">Interview Links\n<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/005-my-top-10-excel-keyboard-shortcuts-excel-podcast\/#Connect_with_Me\" title=\"Connect with Me\">Connect with Me<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/005-my-top-10-excel-keyboard-shortcuts-excel-podcast\/#Listen_to_the_MyExcelOnline_Podcast_on_your_favorite_platform\" title=\"Listen to the MyExcelOnline Podcast on your favorite platform!\">Listen to the MyExcelOnline Podcast on your favorite platform!<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/005-my-top-10-excel-keyboard-shortcuts-excel-podcast\/#Free_Resources\" title=\"Free Resources!\">Free Resources!<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/005-my-top-10-excel-keyboard-shortcuts-excel-podcast\/#Thanks_for_Listening\" title=\"Thanks for Listening!\">Thanks for Listening!<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Top_10_Excel_Keyboard_Shortcuts\"><\/span><strong>Top 10 Excel Keyboard Shortcuts<br \/>\n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-f1-hideunhide-teh-ribbon\/\" target=\"_blank\" rel=\"noopener\"><em>#10: <\/em>CTRL <\/a><\/strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-f1-hideunhide-teh-ribbon\/\" target=\"_blank\" rel=\"noopener\">+<\/a><strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-f1-hideunhide-teh-ribbon\/\" target=\"_blank\" rel=\"noopener\"> F1<\/a> <\/strong>Hides\/Shows the Ribbon Menu<strong><em><br \/>\n<\/em><\/strong><\/p>\n<p><a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-backspace-go-back-to-active-cell-in-excel\/\" target=\"_blank\" rel=\"noopener\"><strong><em>#9: <\/em>CTRL <\/strong>+<strong> Backspace<\/strong> <\/a>Go back to the active cell<em><br \/>\n<\/em><\/p>\n<p><a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/insert-or-delete-rows-and-columns-in-excel\/\" target=\"_blank\" rel=\"noopener\"><strong><em>#8: <\/em>CTRL <\/strong>+<strong> &#8211;<\/strong> or<\/a><strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/insert-or-delete-rows-and-columns-in-excel\/\" target=\"_blank\" rel=\"noopener\"> +<\/a>\u00a0<\/strong> Delete or Insert a Row\/Column<\/p>\n<p><a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-dr-copy-downright\/\" target=\"_blank\" rel=\"noopener\"><strong><em>#7: <\/em>CTRL <\/strong>+<strong> D <\/strong>or<strong> R<\/strong><\/a><strong>\u00a0<\/strong> Copy Down or Copy Right<\/p>\n<p><a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/f4-repeat-last-action\/\" target=\"_blank\" rel=\"noopener\"><strong><em>#6: <\/em>F4<\/strong><\/a><strong>\u00a0<\/strong> Repeats last command or <a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-function-introduction\/\" target=\"_blank\" rel=\"noopener\">Absolute Reference<\/a> for formulas<\/p>\n<p><strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-asterisk-highlight-all-your-data-excel-shortcut\/\" target=\"_blank\" rel=\"noopener\"><em>#5: <\/em>CTRL <\/a><\/strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-asterisk-highlight-all-your-data-excel-shortcut\/\" target=\"_blank\" rel=\"noopener\">+<\/a><strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-asterisk-highlight-all-your-data-excel-shortcut\/\" target=\"_blank\" rel=\"noopener\"> *<\/a>\u00a0<\/strong> Highlights all your range of data<\/p>\n<p><a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-shift-arrows-movehighlight-cells\/\" target=\"_blank\" rel=\"noopener\"><strong><em>#4: <\/em>CTRL <\/strong>+<strong> SHIFT <\/strong>+<strong> &#x2194; \u21a8 <\/strong><\/a>Move to last cell or Highlight to last cell in your data<\/p>\n<p><a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/f9-check-your-math\/\" target=\"_blank\" rel=\"noopener\"><strong><em>#3: <\/em>F9 <\/strong><\/a>Check your math<\/p>\n<p><a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-enter-fill-down\/\" target=\"_blank\"><strong><em>#2: <\/em>CTRL <\/strong>+<strong> ENTER <\/strong><\/a>Fill down<\/p>\n<p><a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-1-format-cells\/\" target=\"_blank\" rel=\"noopener\"><strong><em>#1: <\/em>CTRL <\/strong>+<strong> 1 <\/strong><\/a>Format Dialogue Box<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Interview_Links\"><\/span><strong>Interview Links<br \/>\n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/support.office.com\/en-us\/article\/Excel-shortcut-and-function-keys-1798d9d5-842a-42b8-9c99-9b7213f0040f\" target=\"_blank\" rel=\"noopener nofollow\">Excel Shortcut and Function Keys<\/a> by Office.com<\/p>\n<p>My tip #9 was inspired by Mr.Excel&#8217;s XL Book:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.amazon.com\/gp\/product\/1615470409\/ref=as_li_qf_sp_asin_il_tl?ie=UTF8&amp;camp=1789&amp;creative=9325&amp;creativeASIN=1615470409&amp;linkCode=as2&amp;tag=myexcelonline-20&amp;linkId=OGEUF5TJAULYG7GR\" target=\"_blank\" rel=\"noopener nofollow\">MR EXCEL XL: The 40 Greatest Excel Tips of All Time<\/a> on Amazon<\/li>\n<li><a href=\"https:\/\/www.e-junkie.com\/ecom\/gb.php?cl=211017&amp;c=ib&amp;aff=277028\" target=\"_blank\" rel=\"noopener nofollow\">MR EXCEL XL: The 40 Greatest Excel Tips of All Time<\/a> eBook on the MrExcel store<\/li>\n<li><a href=\"http:\/\/www.mrexcel.com\/store\/index.php?l=product_detail&amp;p=319\" target=\"_blank\" rel=\"noopener nofollow\">MR EXCEL XL: The 40 Greatest Excel Tips of All Time<\/a> Print Edition on the MrExcel store<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.e-junkie.com\/ecom\/gb.php?cl=211017&amp;c=ib&amp;aff=277028\" target=\"_blank\" rel=\"noopener nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-543 size-thumbnail\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/mrexcelXL-150x150.jpg\" alt=\"mrexcelXL\" width=\"150\" height=\"150\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Connect_with_Me\"><\/span><strong>Connect with Me<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/www.linkedin.com\/profile\/view?id=145251116&amp;trk=nav_responsive_tab_profile\" target=\"_blank\" rel=\"noopener nofollow\">LinkedIn<\/a><\/li>\n<li><a href=\"https:\/\/www.facebook.com\/pages\/myexcelonlinecom\/264935273678340?sk=timeline\" target=\"_blank\" rel=\"noopener nofollow\">Facebook<\/a><\/li>\n<li><a href=\"https:\/\/twitter.com\/myexcelonline\" target=\"_blank\" rel=\"noopener nofollow\">Twitter<\/a><\/li>\n<\/ul>\n<h2 class=\"text-center\"><span class=\"ez-toc-section\" id=\"Listen_to_the_MyExcelOnline_Podcast_on_your_favorite_platform\"><\/span><strong>Listen to the MyExcelOnline Podcast on your favorite platform!<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/itunes.apple.com\/us\/podcast\/my-excel-online-podcast\/id1019164720?l=en\" target=\"_blank\" rel=\"noopener nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1057 size-medium aligncenter\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/available-on-itunes-logo-300x112.jpg\" alt=\"\" width=\"300\" height=\"112\" title=\"\"><\/a><\/p>\n<p><a href=\"http:\/\/www.stitcher.com\/s?fid=69832&amp;refid=stpr\" target=\"_blank\" rel=\"noopener nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1051 size-full aligncenter\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Stitcher-button.png\" alt=\"\" width=\"300\" height=\"150\" title=\"\"><\/a><\/p>\n<p><a href=\"https:\/\/play.google.com\/music\/m\/I5hjkav2s3dgtv72ovqol3qbgre?t=My_Excel_Online_Podcast&amp;pcampaignid=MKT-na-all-co-pr-mu-pod-16\" target=\"_blank\" rel=\"noopener nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1052 size-medium aligncenter\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/google-300x116.png\" alt=\"\" width=\"300\" height=\"116\" title=\"\"><\/a><\/p>\n<p><a href=\"https:\/\/www.iheart.com\/show\/263-my-excel-online-podc\/\" target=\"_blank\" rel=\"noopener nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1064 size-medium aligncenter\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/iheart-300x80.png\" alt=\"\" width=\"300\" height=\"80\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Free_Resources\"><\/span><strong>Free Resources!<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol>\n<ol>\n<li><strong>Excel Tutorial <\/strong><strong>Blog<\/strong><strong>:<\/strong> Learn all the essential tips to get you up and running and using Excel to its full potential.\u00a0 Choose from Formulas, Pivot Tables, Charts, Analysis, Shortcuts, Macros plus more &gt;&gt;\u00a0<a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/\" target=\"_blank\" rel=\"noopener\"><strong>CLICK HERE TO VIEW<\/strong><\/a><\/li>\n<\/ol>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li><strong>Free Excel Webinars:<\/strong> Learn the power of Pivot Tables and Power Query with our free webinars. <strong>\u00a0<a href=\"\/\/www.myexcelonline.com\/meo-staging\/115-23.html\" target=\"_blank\" rel=\"noopener\">CLICK HERE TO VIEW NOW<\/a><\/strong><\/li>\n<\/ol>\n<p><a href=\"\/\/www.myexcelonline.com\/meo-staging\/115-23.html\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1015 size-large\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/Free-Webinars-1024x512.jpg\" alt=\"\" width=\"1024\" height=\"512\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Thanks_for_Listening\"><\/span><strong>Thanks for Listening!<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Thank you for joining me this week. If you have some feedback that you\u2019d like to share, then please leave a note in the comment section below!<\/p>\n<p>If you enjoyed this episode, please\u00a0<strong>share<\/strong>\u00a0it using the social media buttons you see at the bottom of the post.<\/p>\n<p>Also,\u00a0<strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/itune\" target=\"_blank\" rel=\"noopener\">please leave an honest review for The MyExcelOnline Podcast on iTunes<\/a>!<\/strong>\u00a0Ratings and reviews\u00a0are\u00a0<strong>extremely<\/strong>\u00a0<strong>helpful<\/strong>\u00a0and greatly appreciated! They do matter in the rankings of the show, and I read each and every one of them.<\/p>\n<p>If you have any questions you can send me an email to <strong><a href=\"mailto:podcast@myexcelonline.com\" target=\"_blank\" rel=\"noopener\">podcast@myexcelonline.com<\/a><\/strong><\/p>\n<p>Don\u2019t forget to subscribe to the show on\u00a0<strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/itune\" target=\"_blank\" rel=\"noopener\">iTunes<\/a><\/strong>\u00a0to get automatic\u00a0updates so you don&#8217;t miss out on these awesome interviews and Excel insights!<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Listen on Web Browser &gt;&gt; Excel Keyboard shortcuts are used by almost every one of the 750 million Microsoft Excel users worldwide.\u00a0 They range from the CTRL combinations shortcuts to the Function keys shortcuts as well as many other Excel keyboard shortcuts. In this episode I go through my top 10 favorite Excel keyboard shortcuts [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":7693,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"005: My Top 10 Excel Keyboard Shortcuts","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[334],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/7787"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=7787"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/7787\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/7693"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=7787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=7787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=7787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}