{"id":472,"date":"2016-03-09T06:39:20","date_gmt":"2016-03-09T06:39:20","guid":{"rendered":"http:\/\/sprunworld.com\/?p=472"},"modified":"2016-07-06T10:35:55","modified_gmt":"2016-07-06T10:35:55","slug":"excel-keyboard-shortcuts-that-will-really-save-your-time","status":"publish","type":"post","link":"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/","title":{"rendered":"Excel Keyboard Shortcuts That Will Really Save Your Time"},"content":{"rendered":"<p><a href=\"http:\/\/sprunworld.com\/wordpress\/wp-content\/uploads\/2016\/03\/keyboard.png\" rel=\"attachment wp-att-473\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-473\" src=\"http:\/\/sprunworld.com\/wordpress\/wp-content\/uploads\/2016\/03\/keyboard-300x138.png\" alt=\"Excel keyboard shortcut keys\" width=\"300\" height=\"138\" title=\"Excel Keyboard Shortcuts That Will Really Save Your Time\" srcset=\"https:\/\/sprunworld.com\/wordpress\/wp-content\/uploads\/2016\/03\/keyboard-300x138.png 300w, https:\/\/sprunworld.com\/wordpress\/wp-content\/uploads\/2016\/03\/keyboard.png 650w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Are you using computer frequently. Then you must have come across spread sheets \/ excel sheets. <a href=\"https:\/\/office.live.com\/start\/Excel.aspx\" target=\"_blank\">Excel sheet<\/a> have tons of features to do your work, calculations etc. in an easier way. In the same way using excel keyboard shortcut is also an easier and quicker way of navigating and executing commands in computer software programs. It really saves your time.<!--more--><\/p>\n<h2><strong>Excel keyboard shortcuts:<\/strong><\/h2>\n<p>CTRL+SHIFT+L (Turn On\/Off Filter)<\/p>\n<p>CTRL+F1 (Expand or collapse ribbon)<\/p>\n<p>Ctrl+Z (Undo)<\/p>\n<p>Ctrl+Y (Redo)<\/p>\n<p>CTRL+Arrow keys (Navigate around the workbook)<\/p>\n<p>CTRL+ALT+V (Display the Paste Special dialog box)<\/p>\n<p>ALT+H (home)<\/p>\n<p>Alt +F (find)<\/p>\n<p>Alt + D (font)<\/p>\n<p>Alt + G (Go to)<\/p>\n<p>ALT+ES &#8211; \u00a0(Paste Special &gt; Values)<\/p>\n<p>ALT + =\u00a0 &#8211; (Automatically sum)<\/p>\n<p>CTRL + PAGEUP \/ PAGE DOWN &#8211; (Jump from one sheet to another)<\/p>\n<p>CTRL + \u2018-\u2018\u00a0 &#8211; (control minus will delete the coloum your cursor is in)<\/p>\n<p>CTRL + \u2018+\u2019 &#8211; (control plus will add the new coloum your)<\/p>\n<p>CTRL+SHIFT+L &#8211;\u00a0(Toggle Autofilter)<\/p>\n<p>Ctrl+Shift+drag &#8211; (Drag and insert copy)<\/p>\n<p>Ctrl+Shift+*\u00a0 &#8211; (Select current region around active cell)<\/p>\n<p>CTRL+K\u00a0 &#8211; (Add Hyperlink)<\/p>\n<p>Ctrl+Shift+: &#8211; (Insert current time)<\/p>\n<p>CTRL+T &#8211; (Insert Table)<\/p>\n<p>F4 \u2013 Change cell reference style while editing formulas<\/p>\n<p>F2 \u2013 Edit a cell<\/p>\n<p>Share us your favorite Excel keyboard short keys and will include it in this list, so that other visitors can also make use of your valuable tip.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Are you using computer frequently. Then you must have come across spread sheets \/ excel sheets. Excel sheet have tons of features to do your work, calculations etc. in an easier way. In the same way using excel keyboard shortcut is also an easier and quicker way of navigating and executing commands in computer software &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[59,125],"tags":[136,135],"class_list":["post-472","post","type-post","status-publish","format-standard","hentry","category-internet","category-software","tag-excel-keyboard-shoort-keys","tag-excel-short-keys","item-wrap"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel Keyboard Shortcuts That Will Really Save Your Time - SprunWorld<\/title>\n<meta name=\"description\" content=\"using excel keyboard shortcuts is an easier and quicker way to navigating and executing commands in computer software programs. It really saves your time.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Keyboard Shortcuts That Will Really Save Your Time - SprunWorld\" \/>\n<meta property=\"og:description\" content=\"using excel keyboard shortcuts is an easier and quicker way to navigating and executing commands in computer software programs. It really saves your time.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/\" \/>\n<meta property=\"og:site_name\" content=\"SprunWorld\" \/>\n<meta property=\"article:published_time\" content=\"2016-03-09T06:39:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-07-06T10:35:55+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/sprunworld.com\/wordpress\/wp-content\/uploads\/2016\/03\/keyboard-300x138.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/sprunworld.com\/wordpress\/#\/schema\/person\/6004b34d4b0d9440d7ab4c96bcfbe013\"},\"headline\":\"Excel Keyboard Shortcuts That Will Really Save Your Time\",\"datePublished\":\"2016-03-09T06:39:20+00:00\",\"dateModified\":\"2016-07-06T10:35:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/\"},\"wordCount\":243,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sprunworld.com\/wordpress\/#organization\"},\"image\":{\"@id\":\"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/sprunworld.com\/wordpress\/wp-content\/uploads\/2016\/03\/keyboard-300x138.png\",\"keywords\":[\"Excel keyboard shoort keys\",\"Excel short keys\"],\"articleSection\":[\"Internet\",\"Software\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/\",\"url\":\"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/\",\"name\":\"Excel Keyboard Shortcuts That Will Really Save Your Time - SprunWorld\",\"isPartOf\":{\"@id\":\"https:\/\/sprunworld.com\/wordpress\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/sprunworld.com\/wordpress\/wp-content\/uploads\/2016\/03\/keyboard-300x138.png\",\"datePublished\":\"2016-03-09T06:39:20+00:00\",\"dateModified\":\"2016-07-06T10:35:55+00:00\",\"description\":\"using excel keyboard shortcuts is an easier and quicker way to navigating and executing commands in computer software programs. It really saves your time.\",\"breadcrumb\":{\"@id\":\"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/#primaryimage\",\"url\":\"http:\/\/sprunworld.com\/wordpress\/wp-content\/uploads\/2016\/03\/keyboard-300x138.png\",\"contentUrl\":\"http:\/\/sprunworld.com\/wordpress\/wp-content\/uploads\/2016\/03\/keyboard-300x138.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sprunworld.com\/wordpress\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Keyboard Shortcuts That Will Really Save Your Time\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sprunworld.com\/wordpress\/#website\",\"url\":\"https:\/\/sprunworld.com\/wordpress\/\",\"name\":\"SprunWorld\",\"description\":\"All About Tech and Net\",\"publisher\":{\"@id\":\"https:\/\/sprunworld.com\/wordpress\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sprunworld.com\/wordpress\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/sprunworld.com\/wordpress\/#organization\",\"name\":\"SprunWorld\",\"url\":\"https:\/\/sprunworld.com\/wordpress\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sprunworld.com\/wordpress\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/sprunworld.com\/wordpress\/wp-content\/uploads\/2022\/08\/Logo.png\",\"contentUrl\":\"https:\/\/sprunworld.com\/wordpress\/wp-content\/uploads\/2022\/08\/Logo.png\",\"width\":187,\"height\":37,\"caption\":\"SprunWorld\"},\"image\":{\"@id\":\"https:\/\/sprunworld.com\/wordpress\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/sprunworld.com\/wordpress\/#\/schema\/person\/6004b34d4b0d9440d7ab4c96bcfbe013\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sprunworld.com\/wordpress\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/dafb07a0ee7282c246be82320c0c507e742b8126dcb9d477b200d683a130d6d5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/dafb07a0ee7282c246be82320c0c507e742b8126dcb9d477b200d683a130d6d5?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\/\/sprunworld.com\/wordpress\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Keyboard Shortcuts That Will Really Save Your Time - SprunWorld","description":"using excel keyboard shortcuts is an easier and quicker way to navigating and executing commands in computer software programs. It really saves your time.","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:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/","og_locale":"en_US","og_type":"article","og_title":"Excel Keyboard Shortcuts That Will Really Save Your Time - SprunWorld","og_description":"using excel keyboard shortcuts is an easier and quicker way to navigating and executing commands in computer software programs. It really saves your time.","og_url":"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/","og_site_name":"SprunWorld","article_published_time":"2016-03-09T06:39:20+00:00","article_modified_time":"2016-07-06T10:35:55+00:00","og_image":[{"url":"http:\/\/sprunworld.com\/wordpress\/wp-content\/uploads\/2016\/03\/keyboard-300x138.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/#article","isPartOf":{"@id":"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/"},"author":{"name":"admin","@id":"https:\/\/sprunworld.com\/wordpress\/#\/schema\/person\/6004b34d4b0d9440d7ab4c96bcfbe013"},"headline":"Excel Keyboard Shortcuts That Will Really Save Your Time","datePublished":"2016-03-09T06:39:20+00:00","dateModified":"2016-07-06T10:35:55+00:00","mainEntityOfPage":{"@id":"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/"},"wordCount":243,"commentCount":0,"publisher":{"@id":"https:\/\/sprunworld.com\/wordpress\/#organization"},"image":{"@id":"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/#primaryimage"},"thumbnailUrl":"http:\/\/sprunworld.com\/wordpress\/wp-content\/uploads\/2016\/03\/keyboard-300x138.png","keywords":["Excel keyboard shoort keys","Excel short keys"],"articleSection":["Internet","Software"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/","url":"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/","name":"Excel Keyboard Shortcuts That Will Really Save Your Time - SprunWorld","isPartOf":{"@id":"https:\/\/sprunworld.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/#primaryimage"},"image":{"@id":"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/#primaryimage"},"thumbnailUrl":"http:\/\/sprunworld.com\/wordpress\/wp-content\/uploads\/2016\/03\/keyboard-300x138.png","datePublished":"2016-03-09T06:39:20+00:00","dateModified":"2016-07-06T10:35:55+00:00","description":"using excel keyboard shortcuts is an easier and quicker way to navigating and executing commands in computer software programs. It really saves your time.","breadcrumb":{"@id":"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/#primaryimage","url":"http:\/\/sprunworld.com\/wordpress\/wp-content\/uploads\/2016\/03\/keyboard-300x138.png","contentUrl":"http:\/\/sprunworld.com\/wordpress\/wp-content\/uploads\/2016\/03\/keyboard-300x138.png"},{"@type":"BreadcrumbList","@id":"https:\/\/sprunworld.com\/wordpress\/excel-keyboard-shortcuts-that-will-really-save-your-time\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sprunworld.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Excel Keyboard Shortcuts That Will Really Save Your Time"}]},{"@type":"WebSite","@id":"https:\/\/sprunworld.com\/wordpress\/#website","url":"https:\/\/sprunworld.com\/wordpress\/","name":"SprunWorld","description":"All About Tech and Net","publisher":{"@id":"https:\/\/sprunworld.com\/wordpress\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sprunworld.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/sprunworld.com\/wordpress\/#organization","name":"SprunWorld","url":"https:\/\/sprunworld.com\/wordpress\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sprunworld.com\/wordpress\/#\/schema\/logo\/image\/","url":"https:\/\/sprunworld.com\/wordpress\/wp-content\/uploads\/2022\/08\/Logo.png","contentUrl":"https:\/\/sprunworld.com\/wordpress\/wp-content\/uploads\/2022\/08\/Logo.png","width":187,"height":37,"caption":"SprunWorld"},"image":{"@id":"https:\/\/sprunworld.com\/wordpress\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/sprunworld.com\/wordpress\/#\/schema\/person\/6004b34d4b0d9440d7ab4c96bcfbe013","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sprunworld.com\/wordpress\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/dafb07a0ee7282c246be82320c0c507e742b8126dcb9d477b200d683a130d6d5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dafb07a0ee7282c246be82320c0c507e742b8126dcb9d477b200d683a130d6d5?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/sprunworld.com\/wordpress\/author\/admin\/"}]}},"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"wptouch-new-thumbnail":false,"graphene_slider":false,"graphene_featured_image":false,"post-thumbnail":false,"crp_thumbnail":false},"uagb_author_info":{"display_name":"admin","author_link":"https:\/\/sprunworld.com\/wordpress\/author\/admin\/"},"uagb_comment_info":0,"uagb_excerpt":"Are you using computer frequently. Then you must have come across spread sheets \/ excel sheets. Excel sheet have tons of features to do your work, calculations etc. in an easier way. In the same way using excel keyboard shortcut is also an easier and quicker way of navigating and executing commands in computer software&hellip;","_links":{"self":[{"href":"https:\/\/sprunworld.com\/wordpress\/wp-json\/wp\/v2\/posts\/472","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sprunworld.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sprunworld.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sprunworld.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sprunworld.com\/wordpress\/wp-json\/wp\/v2\/comments?post=472"}],"version-history":[{"count":0,"href":"https:\/\/sprunworld.com\/wordpress\/wp-json\/wp\/v2\/posts\/472\/revisions"}],"wp:attachment":[{"href":"https:\/\/sprunworld.com\/wordpress\/wp-json\/wp\/v2\/media?parent=472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sprunworld.com\/wordpress\/wp-json\/wp\/v2\/categories?post=472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sprunworld.com\/wordpress\/wp-json\/wp\/v2\/tags?post=472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}