{"id":2715,"date":"2026-08-12T12:06:49","date_gmt":"2026-08-12T02:06:49","guid":{"rendered":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?p=2715"},"modified":"2026-08-12T15:03:38","modified_gmt":"2026-08-12T05:03:38","slug":"excel-shortcuts","status":"publish","type":"post","link":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts","title":{"rendered":"30 Excel Shortcuts That Save Hours"},"content":{"rendered":"\n<p class=\"has-normal-font-size wp-block-paragraph\"><strong>Excel keyboard shortcuts let you perform common tasks instantly instead of hunting through menus. The most useful include Ctrl+C and Ctrl+V to copy and paste, Ctrl+Z to undo, Ctrl+Arrow to jump across data, and Alt+= to AutoSum. Learning even ten of them can save you several hours a week.<\/strong><\/p>\n\n\n\n<!--more-->\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-dominant-color=\"586676\" data-has-transparency=\"false\" style=\"--dominant-color: #586676;\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/dwt-30-essential-excel-shortcuts-banner-1024x576.png\" alt=\"Close-up of hands typing 30 essential Excel keyboard shortcuts on a computer keyboard \u2013 Dynamic Web Training\" class=\"wp-image-2716 not-transparent\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/dwt-30-essential-excel-shortcuts-banner-1024x576.png 1024w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/dwt-30-essential-excel-shortcuts-banner-300x169.png 300w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/dwt-30-essential-excel-shortcuts-banner-1536x864.png 1536w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/dwt-30-essential-excel-shortcuts-banner-1200x675.png 1200w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/dwt-30-essential-excel-shortcuts-banner.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Below are 30 of the highest-value Excel shortcuts, grouped by what they do, so you can learn them a few at a time. They are written for Excel on Windows; there is a Mac note near the end. Pick five you would use today, and the rest will follow.<\/p>\n\n\n\n<div class=\"wp-block-group has-background\" style=\"background-color:#f0f9ff\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"has-normal-font-size wp-block-paragraph\"><strong>Free download:<\/strong> grab our one-page <a href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts-cheat-sheet\">Windows &amp; Mac Excel shortcuts cheat sheet<\/a> (PDF), print it, and pin it by your desk.<\/p>\n<\/div><\/div>\n\n\n\n<h2 id=\"h-why-are-excel-keyboard-shortcuts-worth-learning\" class=\"wp-block-heading has-h-4-font-size\">Why are Excel keyboard shortcuts worth learning?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Every time you reach for the mouse to click through a menu, you lose a few seconds. Do that hundreds of times a day and it adds up to real time, and a real break in concentration. Shortcuts keep your hands on the keyboard and your attention on the work. You do not need all 30 at once: learning the handful you use most often is where the biggest time savings come from.<\/p>\n\n\n\n<h2 id=\"h-what-are-the-essential-everyday-excel-shortcuts\" class=\"wp-block-heading has-h-4-font-size\">What are the essential everyday Excel shortcuts?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">These are the ones worth knowing first, because you use them constantly:<\/p>\n\n\n\n<ul class=\"wp-block-list has-normal-font-size\">\n<li><strong>Ctrl + C<\/strong> &#8211; copy<\/li>\n\n\n\n<li><strong>Ctrl + X<\/strong> &#8211; cut<\/li>\n\n\n\n<li><strong>Ctrl + V<\/strong> &#8211; paste<\/li>\n\n\n\n<li><strong>Ctrl + Z<\/strong> &#8211; undo<\/li>\n\n\n\n<li><strong>Ctrl + Y<\/strong> &#8211; redo<\/li>\n\n\n\n<li><strong>Ctrl + S<\/strong> &#8211; save<\/li>\n\n\n\n<li><strong>Ctrl + F<\/strong> &#8211; find<\/li>\n\n\n\n<li><strong>Ctrl + A<\/strong> &#8211; select all<\/li>\n\n\n\n<li><strong>Ctrl + P<\/strong> &#8211; print<\/li>\n<\/ul>\n\n\n\n<h2 id=\"h-which-shortcuts-help-you-navigate-and-select-data-fast\" class=\"wp-block-heading has-h-4-font-size\">Which shortcuts help you navigate and select data fast?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Moving around a big spreadsheet with the mouse is slow. These jump you around instantly:<\/p>\n\n\n\n<ul class=\"wp-block-list has-normal-font-size\">\n<li><strong>Ctrl + Arrow key<\/strong> &#8211; jump to the edge of your data in that direction<\/li>\n\n\n\n<li><strong>Ctrl + Shift + Arrow key<\/strong> &#8211; select everything from the current cell to the edge of the data<\/li>\n\n\n\n<li><strong>Ctrl + Home<\/strong> &#8211; go back to cell A1<\/li>\n\n\n\n<li><strong>Ctrl + Spacebar<\/strong> &#8211; select the entire column<\/li>\n\n\n\n<li><strong>Shift + Spacebar <\/strong>&#8211; select the entire row<\/li>\n<\/ul>\n\n\n\n<h2 id=\"h-what-are-the-best-shortcuts-for-rows-columns-and-cells\" class=\"wp-block-heading has-h-4-font-size\">What are the best shortcuts for rows, columns and cells?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Editing structure is far faster from the keyboard:<\/p>\n\n\n\n<ul class=\"wp-block-list has-normal-font-size\">\n<li><strong>Ctrl + Shift + Plus (+)<\/strong> &#8211; insert rows or columns<\/li>\n\n\n\n<li><strong>Ctrl + Minus (-)<\/strong> &#8211; delete rows or columns<\/li>\n\n\n\n<li><strong>F2<\/strong> &#8211; edit the active cell (jump straight into it)<\/li>\n\n\n\n<li><strong>Ctrl + D<\/strong> &#8211; fill down (copy the cell above into the selection)<\/li>\n\n\n\n<li><strong>Ctrl + R<\/strong> &#8211; fill right (copy the cell to the left)<\/li>\n\n\n\n<li><strong>Ctrl + ; (semicolon)<\/strong> &#8211; insert today\u2019s date<\/li>\n<\/ul>\n\n\n\n<h2 id=\"h-which-shortcuts-speed-up-formatting\" class=\"wp-block-heading has-h-4-font-size\">Which shortcuts speed up formatting?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Formatting is where a lot of clicking hides. These cut it right down:<\/p>\n\n\n\n<ul class=\"wp-block-list has-normal-font-size\">\n<li><strong>Ctrl + B<\/strong> &#8211; bold<\/li>\n\n\n\n<li><strong>Ctrl + 1<\/strong> &#8211; open the Format Cells dialog (the most useful formatting shortcut of all)<\/li>\n\n\n\n<li><strong>Ctrl + 5<\/strong> &#8211; apply strikethrough<\/li>\n\n\n\n<li><strong>Alt + H, H<\/strong> &#8211; open the fill colour menu<\/li>\n\n\n\n<li><strong>Alt + H, M, C<\/strong> &#8211; merge and centre<\/li>\n\n\n\n<li><strong>Ctrl + Shift + % (percent)<\/strong> &#8211; apply percentage format<\/li>\n<\/ul>\n\n\n\n<h2 id=\"h-what-are-the-must-know-formula-and-data-shortcuts\" class=\"wp-block-heading has-h-4-font-size\">What are the must-know formula and data shortcuts?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">A few shortcuts pay for themselves the moment you work with formulas or lists:<\/p>\n\n\n\n<ul class=\"wp-block-list has-normal-font-size\">\n<li><strong>Alt + = (equals)<\/strong> &#8211; AutoSum the selected range<\/li>\n\n\n\n<li><strong>F4<\/strong> &#8211; toggle a formula reference between relative and absolute ($A$1); also repeats your last action<\/li>\n\n\n\n<li><strong>Ctrl + Shift + L<\/strong> &#8211; turn filters on or off<\/li>\n\n\n\n<li><strong>Alt + Down arrow<\/strong> &#8211; open the filter dropdown on the selected column<\/li>\n<\/ul>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">That is 30. If you only remember a few, make them Ctrl + 1, Ctrl + Arrow, Alt + =, Ctrl + D and F4; they cover the most common time sinks.<\/p>\n\n\n\n<h2 id=\"h-are-excel-keyboard-shortcuts-different-on-a-mac\" class=\"wp-block-heading has-h-4-font-size\">Are Excel keyboard shortcuts different on a Mac?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Mostly, you swap <strong>Ctrl for Command (Cmd)<\/strong>. So copy is Cmd+C, save is Cmd+S, and so on. A few differ: Format Cells is Cmd+1, and some Alt-based Windows shortcuts use Control or Option on a Mac. The Ribbon key sequences (the Alt+H style shortcuts) are the main ones that do not translate directly, so on a Mac it is worth learning the equivalents from Excel\u2019s menus.<\/p>\n\n\n\n<h2 id=\"h-what-s-the-fastest-way-to-learn-excel-shortcuts\" class=\"wp-block-heading has-h-4-font-size\">What\u2019s the fastest way to learn Excel shortcuts?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Do not try to memorise all 30 at once. Pick the five you would use most, put them on a sticky note, and force yourself to use them for a week; they become automatic quickly. Our free <a href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts-cheat-sheet\">Windows &amp; Mac Excel shortcuts cheat sheet<\/a> helps (print it and keep it by your keyboard), and hands-on practice with a trainer is faster still.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">For the fundamentals these shortcuts sit on top of, see our <a href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/complete-guide-to-microsoft-excel\">Complete Guide to Microsoft Excel<\/a>. To build real speed and confidence, our <a href=\"https:\/\/www.dynamicwebtraining.com.au\/microsoft-excel-training-courses\/beginner-excel-course\">Excel Beginner course<\/a> covers navigation, formatting and shortcuts hands-on with a Microsoft Certified Trainer, and you can browse every level on our <a href=\"https:\/\/www.dynamicwebtraining.com.au\/microsoft-excel-training-courses\">Microsoft Excel training courses<\/a> page. Once you are quick with the basics, our guides to <a href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide\">Excel Pivot Tables<\/a> and <a href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/xlookup-explained\">XLOOKUP<\/a> are the natural next steps.<\/p>\n\n\n\n<h2 id=\"h-frequently-asked-questions\" class=\"wp-block-heading has-h-4-font-size\">Frequently asked questions<\/h2>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block has-normal-font-size\"><div class=\"schema-faq-section\" id=\"faq-question-1786499847351\"><strong class=\"schema-faq-question\">What are the most useful Excel keyboard shortcuts?<\/strong> <p class=\"schema-faq-answer\">The most useful everyday shortcuts are Ctrl+C (copy), Ctrl+V (paste), Ctrl+Z (undo), Ctrl+S (save), Ctrl+Arrow to jump across data, Ctrl+1 to open Format Cells, and Alt+= to AutoSum. Learning even ten shortcuts noticeably speeds up your work.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1786499864514\"><strong class=\"schema-faq-question\">What is the shortcut to sum a column in Excel?<\/strong> <p class=\"schema-faq-answer\">Select the cell below the column of numbers and press Alt+= (Alt and the equals key). This inserts an AutoSum formula for the range above. Press Enter to confirm it.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1786499876902\"><strong class=\"schema-faq-question\">What is the shortcut for strikethrough in Excel?<\/strong> <p class=\"schema-faq-answer\">Select the cell or text and press Ctrl+5. Pressing Ctrl+5 again removes the strikethrough. On a Mac, use Cmd+Shift+X.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1786499894263\"><strong class=\"schema-faq-question\">How do you insert a row in Excel with a shortcut?<\/strong> <p class=\"schema-faq-answer\">Select a row (Shift+Spacebar selects the current row), then press Ctrl+Shift+Plus (+) to insert a new row above it. The same shortcut inserts a column when a column is selected.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1786499908478\"><strong class=\"schema-faq-question\">Do Excel shortcuts work the same on a Mac?<\/strong> <p class=\"schema-faq-answer\">Mostly. On a Mac you generally replace Ctrl with Command (Cmd), so Cmd+C, Cmd+S and so on. A few shortcuts differ, and the Alt-based Ribbon sequences do not translate directly, so it is worth checking the Mac equivalents.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1786499922864\"><strong class=\"schema-faq-question\">How can I remember Excel shortcuts?<\/strong> <p class=\"schema-faq-answer\">Learn a few at a time rather than all at once. Pick the five you would use most, keep a cheat sheet nearby, and use them deliberately for a week until they become automatic. Structured training accelerates this a lot.<\/p> <\/div> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>Excel keyboard shortcuts let you perform common tasks instantly instead of hunting through menus. The most useful include Ctrl+C and Ctrl+V to copy and paste, Ctrl+Z to undo, Ctrl+Arrow to jump across data, and Alt+= to AutoSum. Learning even ten of them can save you several hours a week.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2715","post","type-post","status-publish","format-standard","hentry","category-microsoft-excel"],"yoast_head":"<title>30 Excel Shortcuts That Save Hours<\/title>\n<meta name=\"description\" content=\"View and Share Dynamic Web Training Blog Archives. This is a great source of articles and posts on Computer and IT training, tutorials and insights\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"30 Excel Shortcuts That Save Hours\" \/>\n<meta property=\"og:description\" content=\"30 time-saving Microsoft Excel keyboard shortcuts, grouped by task, with a free printable cheat sheet. Work faster in Excel on Windows and Mac.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts\" \/>\n<meta property=\"og:site_name\" content=\"Dynamic Web Training Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-08-12T02:06:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-08-12T05:03:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/dwt-30-essential-excel-shortcuts-banner.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"900\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dynamic Web Training\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:site\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dynamic Web Training\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts\"},\"author\":{\"name\":\"Dynamic Web Training\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/person\\\/c94653aed4a6decc8e357af0a1082233\"},\"headline\":\"30 Excel Shortcuts That Save Hours\",\"datePublished\":\"2026-08-12T02:06:49+00:00\",\"dateModified\":\"2026-08-12T05:03:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts\"},\"wordCount\":1046,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/dwt-30-essential-excel-shortcuts-banner-1024x576.png\",\"articleSection\":[\"Microsoft Excel\"],\"inLanguage\":\"en-AU\"},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts\",\"name\":\"30 Excel Shortcuts That Save Hours\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/dwt-30-essential-excel-shortcuts-banner-1024x576.png\",\"datePublished\":\"2026-08-12T02:06:49+00:00\",\"dateModified\":\"2026-08-12T05:03:38+00:00\",\"description\":\"30 time-saving Microsoft Excel keyboard shortcuts, grouped by task, with a free printable cheat sheet. Work faster in Excel on Windows and Mac.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#breadcrumb\"},\"mainEntity\":[{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#faq-question-1786499847351\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#faq-question-1786499864514\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#faq-question-1786499876902\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#faq-question-1786499894263\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#faq-question-1786499908478\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#faq-question-1786499922864\"}],\"inLanguage\":\"en-AU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#primaryimage\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/dwt-30-essential-excel-shortcuts-banner.png\",\"contentUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/dwt-30-essential-excel-shortcuts-banner.png\",\"width\":1600,\"height\":900},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Training Blog\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Training\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/category\\\/training\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft Excel\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/category\\\/training\\\/microsoft-excel\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"30 Excel Shortcuts That Save Hours\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\",\"name\":\"Dynamic Web Training Blog\",\"description\":\"The Ultimate Training Experience.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-AU\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\",\"name\":\"Dynamic Web Training\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/logo.png\",\"width\":361,\"height\":109,\"caption\":\"Dynamic Web Training\",\"name\":\"Dynamic Web Training Logo\",\"description\":\"Dynamic Web Training official site logo asset\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/DynamicWebTraining\\\/\",\"https:\\\/\\\/x.com\\\/dynamicwebtrain\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/person\\\/c94653aed4a6decc8e357af0a1082233\",\"name\":\"Dynamic Web Training\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"caption\":\"Dynamic Web Training\"},\"description\":\"This article is written by a senior writer at Dynamic Web Training. Our specialist writers are either Microsoft Certified Trainers, Adobe Certified Professionals or Certified Xero Advisors.\",\"sameAs\":[\"https:\\\/\\\/www.dynamicwebtraining.com.au\",\"https:\\\/\\\/www.facebook.com\\\/DynamicWebTraining\\\/\",\"https:\\\/\\\/www.instagram.com\\\/dynamicwebtraining\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dynamic-web-training\",\"https:\\\/\\\/x.com\\\/dynamicwebtrain\",\"www.youtube.com\\\/@dynamicwebtraining8740\"],\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#faq-question-1786499847351\",\"position\":1,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#faq-question-1786499847351\",\"name\":\"What are the most useful Excel keyboard shortcuts?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"The most useful everyday shortcuts are Ctrl+C (copy), Ctrl+V (paste), Ctrl+Z (undo), Ctrl+S (save), Ctrl+Arrow to jump across data, Ctrl+1 to open Format Cells, and Alt+= to AutoSum. Learning even ten shortcuts noticeably speeds up your work.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#faq-question-1786499864514\",\"position\":2,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#faq-question-1786499864514\",\"name\":\"What is the shortcut to sum a column in Excel?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Select the cell below the column of numbers and press Alt+= (Alt and the equals key). This inserts an AutoSum formula for the range above. Press Enter to confirm it.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#faq-question-1786499876902\",\"position\":3,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#faq-question-1786499876902\",\"name\":\"What is the shortcut for strikethrough in Excel?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Select the cell or text and press Ctrl+5. Pressing Ctrl+5 again removes the strikethrough. On a Mac, use Cmd+Shift+X.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#faq-question-1786499894263\",\"position\":4,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#faq-question-1786499894263\",\"name\":\"How do you insert a row in Excel with a shortcut?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Select a row (Shift+Spacebar selects the current row), then press Ctrl+Shift+Plus (+) to insert a new row above it. The same shortcut inserts a column when a column is selected.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#faq-question-1786499908478\",\"position\":5,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#faq-question-1786499908478\",\"name\":\"Do Excel shortcuts work the same on a Mac?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Mostly. On a Mac you generally replace Ctrl with Command (Cmd), so Cmd+C, Cmd+S and so on. A few shortcuts differ, and the Alt-based Ribbon sequences do not translate directly, so it is worth checking the Mac equivalents.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#faq-question-1786499922864\",\"position\":6,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-shortcuts#faq-question-1786499922864\",\"name\":\"How can I remember Excel shortcuts?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Learn a few at a time rather than all at once. Pick the five you would use most, keep a cheat sheet nearby, and use them deliberately for a week until they become automatic. Structured training accelerates this a lot.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"}]}<\/script>","yoast_head_json":{"title":"30 Excel Shortcuts That Save Hours","description":"View and Share Dynamic Web Training Blog Archives. This is a great source of articles and posts on Computer and IT training, tutorials and insights","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts","og_locale":"en_US","og_type":"article","og_title":"30 Excel Shortcuts That Save Hours","og_description":"30 time-saving Microsoft Excel keyboard shortcuts, grouped by task, with a free printable cheat sheet. Work faster in Excel on Windows and Mac.","og_url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts","og_site_name":"Dynamic Web Training Blog","article_publisher":"https:\/\/www.facebook.com\/DynamicWebTraining\/","article_author":"https:\/\/www.facebook.com\/DynamicWebTraining\/","article_published_time":"2026-08-12T02:06:49+00:00","article_modified_time":"2026-08-12T05:03:38+00:00","og_image":[{"width":1600,"height":900,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/dwt-30-essential-excel-shortcuts-banner.png","type":"image\/png"}],"author":"Dynamic Web Training","twitter_card":"summary_large_image","twitter_creator":"@dynamicwebtrain","twitter_site":"@dynamicwebtrain","twitter_misc":{"Written by":"Dynamic Web Training","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#article","isPartOf":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts"},"author":{"name":"Dynamic Web Training","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233"},"headline":"30 Excel Shortcuts That Save Hours","datePublished":"2026-08-12T02:06:49+00:00","dateModified":"2026-08-12T05:03:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts"},"wordCount":1046,"publisher":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#primaryimage"},"thumbnailUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/dwt-30-essential-excel-shortcuts-banner-1024x576.png","articleSection":["Microsoft Excel"],"inLanguage":"en-AU"},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts","name":"30 Excel Shortcuts That Save Hours","isPartOf":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#primaryimage"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#primaryimage"},"thumbnailUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/dwt-30-essential-excel-shortcuts-banner-1024x576.png","datePublished":"2026-08-12T02:06:49+00:00","dateModified":"2026-08-12T05:03:38+00:00","description":"30 time-saving Microsoft Excel keyboard shortcuts, grouped by task, with a free printable cheat sheet. Work faster in Excel on Windows and Mac.","breadcrumb":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#breadcrumb"},"mainEntity":[{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#faq-question-1786499847351"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#faq-question-1786499864514"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#faq-question-1786499876902"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#faq-question-1786499894263"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#faq-question-1786499908478"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#faq-question-1786499922864"}],"inLanguage":"en-AU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts"]}]},{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#primaryimage","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/dwt-30-essential-excel-shortcuts-banner.png","contentUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/dwt-30-essential-excel-shortcuts-banner.png","width":1600,"height":900},{"@type":"BreadcrumbList","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Training Blog","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/"},{"@type":"ListItem","position":2,"name":"Training","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training"},{"@type":"ListItem","position":3,"name":"Microsoft Excel","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/microsoft-excel"},{"@type":"ListItem","position":4,"name":"30 Excel Shortcuts That Save Hours"}]},{"@type":"WebSite","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/","name":"Dynamic Web Training Blog","description":"The Ultimate Training Experience.","publisher":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-AU"},{"@type":"Organization","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization","name":"Dynamic Web Training","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png","contentUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png","width":361,"height":109,"caption":"Dynamic Web Training","name":"Dynamic Web Training Logo","description":"Dynamic Web Training official site logo asset"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DynamicWebTraining\/","https:\/\/x.com\/dynamicwebtrain"]},{"@type":"Person","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233","name":"Dynamic Web Training","image":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","caption":"Dynamic Web Training"},"description":"This article is written by a senior writer at Dynamic Web Training. Our specialist writers are either Microsoft Certified Trainers, Adobe Certified Professionals or Certified Xero Advisors.","sameAs":["https:\/\/www.dynamicwebtraining.com.au","https:\/\/www.facebook.com\/DynamicWebTraining\/","https:\/\/www.instagram.com\/dynamicwebtraining\/","https:\/\/www.linkedin.com\/company\/dynamic-web-training","https:\/\/x.com\/dynamicwebtrain","www.youtube.com\/@dynamicwebtraining8740"],"url":"https:\/\/www.dynamicwebtraining.com.au"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#faq-question-1786499847351","position":1,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#faq-question-1786499847351","name":"What are the most useful Excel keyboard shortcuts?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"The most useful everyday shortcuts are Ctrl+C (copy), Ctrl+V (paste), Ctrl+Z (undo), Ctrl+S (save), Ctrl+Arrow to jump across data, Ctrl+1 to open Format Cells, and Alt+= to AutoSum. Learning even ten shortcuts noticeably speeds up your work.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#faq-question-1786499864514","position":2,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#faq-question-1786499864514","name":"What is the shortcut to sum a column in Excel?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Select the cell below the column of numbers and press Alt+= (Alt and the equals key). This inserts an AutoSum formula for the range above. Press Enter to confirm it.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#faq-question-1786499876902","position":3,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#faq-question-1786499876902","name":"What is the shortcut for strikethrough in Excel?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Select the cell or text and press Ctrl+5. Pressing Ctrl+5 again removes the strikethrough. On a Mac, use Cmd+Shift+X.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#faq-question-1786499894263","position":4,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#faq-question-1786499894263","name":"How do you insert a row in Excel with a shortcut?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Select a row (Shift+Spacebar selects the current row), then press Ctrl+Shift+Plus (+) to insert a new row above it. The same shortcut inserts a column when a column is selected.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#faq-question-1786499908478","position":5,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#faq-question-1786499908478","name":"Do Excel shortcuts work the same on a Mac?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Mostly. On a Mac you generally replace Ctrl with Command (Cmd), so Cmd+C, Cmd+S and so on. A few shortcuts differ, and the Alt-based Ribbon sequences do not translate directly, so it is worth checking the Mac equivalents.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#faq-question-1786499922864","position":6,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-shortcuts#faq-question-1786499922864","name":"How can I remember Excel shortcuts?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Learn a few at a time rather than all at once. Pick the five you would use most, keep a cheat sheet nearby, and use them deliberately for a week until they become automatic. Structured training accelerates this a lot.","inLanguage":"en-AU"},"inLanguage":"en-AU"}]}},"_links":{"self":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/2715","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/comments?post=2715"}],"version-history":[{"count":2,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/2715\/revisions"}],"predecessor-version":[{"id":2718,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/2715\/revisions\/2718"}],"wp:attachment":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/media?parent=2715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/categories?post=2715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/tags?post=2715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}