{"id":26276,"date":"2016-03-31T21:01:10","date_gmt":"2016-03-31T13:01:10","guid":{"rendered":"https:\/\/www.hongkiat.com\/blog\/?p=26276"},"modified":"2022-03-21T14:48:03","modified_gmt":"2022-03-21T06:48:03","slug":"time-saving-excel-shortcuts","status":"publish","type":"post","link":"https:\/\/www.hongkiat.com\/blog\/time-saving-excel-shortcuts\/","title":{"rendered":"8 Time-Saving Excel Shortcuts [Infographic]"},"content":{"rendered":"<p>Excel has always been associated with <a href=\"https:\/\/www.hongkiat.com\/blog\/survive-office-moving-up-corporate-ladder\/\">office work<\/a> and spreadsheets (and less associated with the oh-so-cool <a href=\"https:\/\/www.hongkiat.com\/blog\/microsoft-excel-artworks\/\">production of artwork<\/a>) which are long, mundane, repetitive tasks that we try to, but can never seem to be able to, avoid doing. That\u2019s why <strong>time-saving tricks and shortcuts<\/strong> are great hacks and timesavers that most of us Excel minions are hungry for.<\/p>\n<p>If you have seen our previous post on <a href=\"https:\/\/www.hongkiat.com\/blog\/excel-tricks\/\">awesome Excel tricks<\/a> that you can impress your boss with, then you will like this other infographic with a few more Excel shortcuts you can hide up your sleeves.<\/p>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/time-saving-excel-shortcuts\/excel-shortcuts-infographic.jpg\" alt=\"excel shortcuts\" width=\"744\" height=\"5209\"><\/figure>","protected":false},"excerpt":{"rendered":"<p>Excel has always been associated with office work and spreadsheets (and less associated with the oh-so-cool production of artwork) which are long, mundane, repetitive tasks that we try to, but can never seem to be able to, avoid doing. That\u2019s why time-saving tricks and shortcuts are great hacks and timesavers that most of us Excel&hellip;<\/p>\n","protected":false},"author":41,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3397],"tags":[55,3701,978],"topic":[4521],"class_list":["entry-content","is-maxi"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.8 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>8 Time-Saving Excel Shortcuts<\/title>\n<meta name=\"description\" content=\"If you have seen our previous post on awesome Excel tricks that you can impress your boss with, then you will like this infographic.\" \/>\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.hongkiat.com\/blog\/time-saving-excel-shortcuts\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"8 Time-Saving Excel Shortcuts [Infographic]\" \/>\n<meta property=\"og:description\" content=\"Excel has always been associated with office work and spreadsheets (and less associated with the oh-so-cool production of artwork) which are long,\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hongkiat.com\/blog\/time-saving-excel-shortcuts\/\" \/>\n<meta property=\"og:site_name\" content=\"Hongkiat\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hongkiatcom\" \/>\n<meta property=\"article:published_time\" content=\"2016-03-31T13:01:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-21T06:48:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/assets.hongkiat.com\/uploads\/time-saving-excel-shortcuts\/excel-shortcuts-infographic.jpg\" \/>\n<meta name=\"author\" content=\"Singyin Lee\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@hongkiat\" \/>\n<meta name=\"twitter:site\" content=\"@hongkiat\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Singyin Lee\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/time-saving-excel-shortcuts\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/time-saving-excel-shortcuts\\\/\"},\"author\":{\"name\":\"Singyin Lee\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/person\\\/8bb3e8d1cb49b3298ea203885023b811\"},\"headline\":\"8 Time-Saving Excel Shortcuts [Infographic]\",\"datePublished\":\"2016-03-31T13:01:10+00:00\",\"dateModified\":\"2022-03-21T06:48:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/time-saving-excel-shortcuts\\\/\"},\"wordCount\":100,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/time-saving-excel-shortcuts\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/time-saving-excel-shortcuts\\\/excel-shortcuts-infographic.jpg\",\"keywords\":[\"Microsoft\",\"Microsoft Excel\",\"Productivity Tips\"],\"articleSection\":[\"Desktop\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/time-saving-excel-shortcuts\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/time-saving-excel-shortcuts\\\/\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/time-saving-excel-shortcuts\\\/\",\"name\":\"8 Time-Saving Excel Shortcuts\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/time-saving-excel-shortcuts\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/time-saving-excel-shortcuts\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/time-saving-excel-shortcuts\\\/excel-shortcuts-infographic.jpg\",\"datePublished\":\"2016-03-31T13:01:10+00:00\",\"dateModified\":\"2022-03-21T06:48:03+00:00\",\"description\":\"If you have seen our previous post on awesome Excel tricks that you can impress your boss with, then you will like this infographic.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/time-saving-excel-shortcuts\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/time-saving-excel-shortcuts\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/time-saving-excel-shortcuts\\\/#primaryimage\",\"url\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/time-saving-excel-shortcuts\\\/excel-shortcuts-infographic.jpg\",\"contentUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/time-saving-excel-shortcuts\\\/excel-shortcuts-infographic.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/time-saving-excel-shortcuts\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"8 Time-Saving Excel Shortcuts [Infographic]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\",\"name\":\"Hongkiat\",\"description\":\"Tech and Design Tips\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\",\"name\":\"Hongkiat.com\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/wp-content\\\/uploads\\\/hkdc-logo-rect-yoast.jpg\",\"contentUrl\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/wp-content\\\/uploads\\\/hkdc-logo-rect-yoast.jpg\",\"width\":1200,\"height\":799,\"caption\":\"Hongkiat.com\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hongkiatcom\",\"https:\\\/\\\/x.com\\\/hongkiat\",\"https:\\\/\\\/www.pinterest.com\\\/hongkiat\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/person\\\/8bb3e8d1cb49b3298ea203885023b811\",\"name\":\"Singyin Lee\",\"description\":\"Singyin is Senior Editor and Writer for Hongkiat. She is allergic to poor Wifi and spun articles, and has been told that she drinks too much coffee. Her sense of humor has been damaged by the Internet.\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/author\\\/sy\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"8 Time-Saving Excel Shortcuts","description":"If you have seen our previous post on awesome Excel tricks that you can impress your boss with, then you will like this infographic.","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.hongkiat.com\/blog\/time-saving-excel-shortcuts\/","og_locale":"en_US","og_type":"article","og_title":"8 Time-Saving Excel Shortcuts [Infographic]","og_description":"Excel has always been associated with office work and spreadsheets (and less associated with the oh-so-cool production of artwork) which are long,","og_url":"https:\/\/www.hongkiat.com\/blog\/time-saving-excel-shortcuts\/","og_site_name":"Hongkiat","article_publisher":"https:\/\/www.facebook.com\/hongkiatcom","article_published_time":"2016-03-31T13:01:10+00:00","article_modified_time":"2022-03-21T06:48:03+00:00","og_image":[{"url":"https:\/\/assets.hongkiat.com\/uploads\/time-saving-excel-shortcuts\/excel-shortcuts-infographic.jpg","type":"","width":"","height":""}],"author":"Singyin Lee","twitter_card":"summary_large_image","twitter_creator":"@hongkiat","twitter_site":"@hongkiat","twitter_misc":{"Written by":"Singyin Lee"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.hongkiat.com\/blog\/time-saving-excel-shortcuts\/#article","isPartOf":{"@id":"https:\/\/www.hongkiat.com\/blog\/time-saving-excel-shortcuts\/"},"author":{"name":"Singyin Lee","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/person\/8bb3e8d1cb49b3298ea203885023b811"},"headline":"8 Time-Saving Excel Shortcuts [Infographic]","datePublished":"2016-03-31T13:01:10+00:00","dateModified":"2022-03-21T06:48:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.hongkiat.com\/blog\/time-saving-excel-shortcuts\/"},"wordCount":100,"commentCount":3,"publisher":{"@id":"https:\/\/www.hongkiat.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/time-saving-excel-shortcuts\/#primaryimage"},"thumbnailUrl":"https:\/\/assets.hongkiat.com\/uploads\/time-saving-excel-shortcuts\/excel-shortcuts-infographic.jpg","keywords":["Microsoft","Microsoft Excel","Productivity Tips"],"articleSection":["Desktop"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.hongkiat.com\/blog\/time-saving-excel-shortcuts\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.hongkiat.com\/blog\/time-saving-excel-shortcuts\/","url":"https:\/\/www.hongkiat.com\/blog\/time-saving-excel-shortcuts\/","name":"8 Time-Saving Excel Shortcuts","isPartOf":{"@id":"https:\/\/www.hongkiat.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.hongkiat.com\/blog\/time-saving-excel-shortcuts\/#primaryimage"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/time-saving-excel-shortcuts\/#primaryimage"},"thumbnailUrl":"https:\/\/assets.hongkiat.com\/uploads\/time-saving-excel-shortcuts\/excel-shortcuts-infographic.jpg","datePublished":"2016-03-31T13:01:10+00:00","dateModified":"2022-03-21T06:48:03+00:00","description":"If you have seen our previous post on awesome Excel tricks that you can impress your boss with, then you will like this infographic.","breadcrumb":{"@id":"https:\/\/www.hongkiat.com\/blog\/time-saving-excel-shortcuts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hongkiat.com\/blog\/time-saving-excel-shortcuts\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hongkiat.com\/blog\/time-saving-excel-shortcuts\/#primaryimage","url":"https:\/\/assets.hongkiat.com\/uploads\/time-saving-excel-shortcuts\/excel-shortcuts-infographic.jpg","contentUrl":"https:\/\/assets.hongkiat.com\/uploads\/time-saving-excel-shortcuts\/excel-shortcuts-infographic.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.hongkiat.com\/blog\/time-saving-excel-shortcuts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.hongkiat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"8 Time-Saving Excel Shortcuts [Infographic]"}]},{"@type":"WebSite","@id":"https:\/\/www.hongkiat.com\/blog\/#website","url":"https:\/\/www.hongkiat.com\/blog\/","name":"Hongkiat","description":"Tech and Design Tips","publisher":{"@id":"https:\/\/www.hongkiat.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hongkiat.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.hongkiat.com\/blog\/#organization","name":"Hongkiat.com","url":"https:\/\/www.hongkiat.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.hongkiat.com\/blog\/wp-content\/uploads\/hkdc-logo-rect-yoast.jpg","contentUrl":"https:\/\/www.hongkiat.com\/blog\/wp-content\/uploads\/hkdc-logo-rect-yoast.jpg","width":1200,"height":799,"caption":"Hongkiat.com"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hongkiatcom","https:\/\/x.com\/hongkiat","https:\/\/www.pinterest.com\/hongkiat\/"]},{"@type":"Person","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/person\/8bb3e8d1cb49b3298ea203885023b811","name":"Singyin Lee","description":"Singyin is Senior Editor and Writer for Hongkiat. She is allergic to poor Wifi and spun articles, and has been told that she drinks too much coffee. Her sense of humor has been damaged by the Internet.","url":"https:\/\/www.hongkiat.com\/blog\/author\/sy\/"}]}},"jetpack_featured_media_url":"https:\/\/","jetpack_shortlink":"https:\/\/wp.me\/p4uxU-6PO","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/26276","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/comments?post=26276"}],"version-history":[{"count":3,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/26276\/revisions"}],"predecessor-version":[{"id":50413,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/26276\/revisions\/50413"}],"wp:attachment":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/media?parent=26276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/categories?post=26276"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/tags?post=26276"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/topic?post=26276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}