{"id":5684,"date":"2022-02-11T06:30:00","date_gmt":"2022-02-11T05:30:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=5684"},"modified":"2026-04-27T19:40:09","modified_gmt":"2026-04-27T17:40:09","slug":"the-best-excel-shortcuts-for-selection","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/excel\/the-best-excel-shortcuts-for-selection\/","title":{"rendered":"16 Best Excel Selection Shortcuts to Work Faster (Cheat Sheet)"},"content":{"rendered":"\n<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [\n    {\n      \"@type\": \"Question\",\n      \"name\": \"What is the shortcut to select an entire column in Excel?\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"Press CTRL + SPACE to select the entire column of the active cell. To select an entire row instead, press SHIFT + SPACE.\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"How do I select all data in an Excel table with one shortcut?\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"Click any cell inside the table and press CTRL + A. Press CTRL + A a second time to extend the selection to the entire worksheet including headers.\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"How to select thousands of rows in Excel without scrolling?\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"Click the first cell, then press CTRL + SHIFT + DOWN ARROW. Excel will instantly select every row down to the last filled cell, regardless of how many thousands of rows the table contains.\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"What does F8 do in Excel?\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"F8 toggles the extended selection mode in Excel. When active, every arrow key press extends the current selection without needing to hold SHIFT. Press F8 again to deactivate it.\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"How do I jump back to cell A1 in Excel?\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"Press CTRL + HOME to instantly jump to cell A1. To select every cell from your current position back to A1, press CTRL + SHIFT + HOME.\"\n      }\n    }\n  ]\n}\n<\/script>\n\n\n\n<p class=\"has-text-align-center\"><strong><em>The 16 best Excel selection shortcuts to work faster with the keyboard only.<\/em><\/strong><\/p>\n\n\n\n<p>Mastering these key combinations is the single fastest way to boost your productivity in Excel, whether you handle small tables or spreadsheets with thousands of rows.<\/p>\n\n\n\n<p>This guide covers <strong>cell-by-cell selections, jump-to-edge shortcuts, screen-by-screen navigation, and full table selection<\/strong> \u2014 everything you need to stop using the mouse in <a href=\"https:\/\/en.wikipedia.org\/wiki\/Microsoft_Excel\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft Excel<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-excel-selection-of-8-shortcuts-quick-reference-cheat-sheet\">Excel selection of 8 shortcuts: quick reference cheat sheet<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Action<\/th><th>Shortcut<\/th><\/tr><\/thead><tbody><tr><td>Extend selection one cell up<\/td><td><code><strong>SHIFT + \u2191<\/strong><\/code><\/td><\/tr><tr><td>Extend selection one cell down<\/td><td><code><strong>SHIFT + \u2193<\/strong><\/code><\/td><\/tr><tr><td>Extend selection to last cell with data<\/td><td><code><strong>CTRL + SHIFT + \u2193<\/strong><\/code><\/td><\/tr><tr><td>Select entire row<\/td><td><code><strong>SHIFT + SPACE<\/strong><\/code><\/td><\/tr><tr><td>Select entire column<\/td><td><code><strong>CTRL + SPACE<\/strong><\/code><\/td><\/tr><tr><td>Select entire table<\/td><td><code><strong>CTRL + A<\/strong><\/code><\/td><\/tr><tr><td>Jump to cell A1<\/td><td><code><strong>CTRL + HOME<\/strong><\/code><\/td><\/tr><tr><td>Toggle extended selection mode<\/td><td><code><strong>F8<\/strong><\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-cell-by-cell-selection-shortcuts-in-excel\">Cell-by-cell selection shortcuts in Excel<\/h2>\n\n\n\n<p>The most basic Excel selection shortcuts let you extend your selection one cell at a time, in any direction. These four combinations are the foundation every Excel user should memorize first.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-extend-the-selection-vertically\">Extend the selection vertically<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Extend the Excel selection one cell up: <strong>SHIFT + ARROW UP<\/strong><\/li>\n\n\n\n<li>Extend the Excel selection one cell down: <strong>SHIFT + ARROW DOWN<\/strong><\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-extend-the-selection-horizontally\">Extend the selection horizontally<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Extend the Excel selection one cell to the right: <strong>SHIFT + RIGHT ARROW<\/strong><\/li>\n\n\n\n<li>Extend the Excel selection one cell to the left: <strong>SHIFT + LEFT ARROW<\/strong><\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-jump-to-last-cell-selection-shortcuts\">Jump-to-last-cell selection shortcuts<\/h2>\n\n\n\n<p>These are the most powerful Excel shortcuts for working with large datasets. Adding <code>CTRL<\/code> to the previous shortcuts makes Excel jump straight to the last filled cell in any direction, instantly selecting thousands of rows or columns.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-select-to-the-last-cell-vertically\">Select to the last cell vertically<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Extend the Excel selection to the last filled cell above: <strong>CTRL + SHIFT + ARROW UP<\/strong><\/li>\n\n\n\n<li>Extend the Excel selection to the last filled cell below: <strong>CTRL + SHIFT + DOWN ARROW<\/strong><\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-select-to-the-last-cell-horizontally\">Select to the last cell horizontally<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Extend the Excel selection to the last filled cell on the right: <strong>CTRL + SHIFT + RIGHT ARROW<\/strong><\/li>\n\n\n\n<li>Extend the Excel selection to the last filled cell on the left: <strong>CTRL + SHIFT + LEFT ARROW<\/strong><\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-screen-by-screen-excel-selection-shortcuts\">Screen-by-screen Excel selection shortcuts<\/h2>\n\n\n\n<p>When working with medium-sized tables that don&#8217;t fit on one screen, the page-up and page-down shortcuts let you extend your selection one viewport at a time. Useful for visual review of large datasets.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-extend-the-selection-vertically-by-one-screen\">Extend the selection vertically by one screen<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Extend the Excel selection to the next screen above: <strong>SHIFT + PAGE UP<\/strong><\/li>\n\n\n\n<li>Extend the Excel selection to the next screen below: <strong>SHIFT + PAGE DOWN<\/strong><\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-extend-the-selection-horizontally-by-one-screen\">Extend the selection horizontally by one screen<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Extend the Excel selection to the next screen on the right: <strong>ALT + SHIFT + PAGE DOWN<\/strong><\/li>\n\n\n\n<li>Extend the Excel selection to the next screen on the left: <strong>ALT + SHIFT + PAGE UP<\/strong><\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-row-column-and-full-table-selection-shortcuts\">Row, column and full-table selection shortcuts<\/h2>\n\n\n\n<p>Beyond cell-by-cell navigation, Excel offers powerful shortcuts to select an entire row, an entire column, or the whole worksheet in a single keystroke. These are essential for formatting, deleting, or copying large blocks of data.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-jump-to-the-first-or-last-cell-of-the-file\">Jump to the first or last cell of the file<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Extend the Excel selection to the first cell of the row: <strong>SHIFT + HOME<\/strong><\/li>\n\n\n\n<li>Extend the Excel selection to the first cell of the file (A1): <strong>CTRL + SHIFT + HOME<\/strong><\/li>\n\n\n\n<li>Extend the Excel selection to the last cell of the file: <strong>CTRL + SHIFT + END<\/strong><\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-activate-the-excel-extended-selection-mode\">Activate the Excel extended selection mode<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Toggle the extended selection mode on or off: <strong>F8<\/strong><\/li>\n<\/ol>\n\n\n\n<p><strong>Pro tip:<\/strong> when extended selection mode is active (you&#8217;ll see &#8220;Extend Selection&#8221; in the Excel status bar), every arrow key press extends your selection without needing to hold SHIFT. Press <strong>F8<\/strong> again to deactivate it.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-faq-on-excel-selection-shortcuts\">FAQ on Excel selection shortcuts<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-what-is-the-shortcut-to-select-an-entire-column-in-excel\">What is the shortcut to select an entire column in Excel?<\/h3>\n\n\n\n<p>Press <strong>CTRL + SPACE<\/strong> to select the entire column of the active cell. To select an entire row instead, press <strong>SHIFT + SPACE<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-how-to-select-thousands-of-rows-in-excel-without-scrolling\">How to select thousands of rows in Excel without scrolling?<\/h3>\n\n\n\n<p>Click the first cell, then press <strong>CTRL + SHIFT + DOWN ARROW<\/strong>. Excel will instantly select every row down to the last filled cell, no matter how many thousands of rows your table contains.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-what-does-f8-do-in-excel\">What does F8 do in Excel?<\/h3>\n\n\n\n<p>F8 toggles the extended selection mode. When active, every arrow key press extends the current selection without holding SHIFT. Press F8 a second time to turn it off.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conclusion-master-excel-with-the-keyboard-only\">Conclusion: master Excel with the keyboard only<\/h2>\n\n\n\n<p>These 16 Excel selection shortcuts cover every scenario you&#8217;ll face daily, from selecting a single cell to grabbing an entire dataset of thousands of rows in two keystrokes. Memorizing them will save you hours every week and let you keep both hands on the keyboard.<\/p>\n\n\n\n<p>To go further with Excel productivity, this other tutorial explains <a href=\"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/\">how to display the day name from a date with an Excel formula<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>The 16 best Excel selection shortcuts to work faster with the keyboard only. Mastering these key combinations is the single fastest way to boost your productivity in Excel, whether you handle small tables or spreadsheets with thousands of rows. <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/excel\/the-best-excel-shortcuts-for-selection\/\" title=\"16 Best Excel Selection Shortcuts to Work Faster (Cheat Sheet)\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":5616,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[457],"tags":[],"class_list":{"0":"post-5684","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>16 Best Excel Selection Shortcuts to Work Faster - Cheat Sheet<\/title>\n<meta name=\"description\" content=\"What are the best Excel shortcuts for selection? A selection of the most effective Excel shortcuts for making selections of cells and more.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/excel\/the-best-excel-shortcuts-for-selection\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"16 Best Excel Selection Shortcuts to Work Faster (Cheat Sheet)\" \/>\n<meta property=\"og:description\" content=\"What are the best Excel shortcuts for selection? A selection of the most effective Excel shortcuts for making selections of cells and more.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/excel\/the-best-excel-shortcuts-for-selection\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-11T05:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-27T17:40:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/office-workspaces-colorful-C12F0EE24A6_1920x1080.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/excel\\\/the-best-excel-shortcuts-for-selection\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/excel\\\/the-best-excel-shortcuts-for-selection\\\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#\\\/schema\\\/person\\\/406a9576b52944f018739a42046873ef\"},\"headline\":\"16 Best Excel Selection Shortcuts to Work Faster (Cheat Sheet)\",\"datePublished\":\"2022-02-11T05:30:00+00:00\",\"dateModified\":\"2026-04-27T17:40:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/excel\\\/the-best-excel-shortcuts-for-selection\\\/\"},\"wordCount\":752,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/excel\\\/the-best-excel-shortcuts-for-selection\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/expert-only.com\\\/wp-content\\\/uploads\\\/2017\\\/08\\\/office-workspaces-colorful-C12F0EE24A6_1920x1080.jpeg\",\"articleSection\":[\"Excel Tips\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/expert-only.com\\\/en\\\/excel\\\/the-best-excel-shortcuts-for-selection\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/excel\\\/the-best-excel-shortcuts-for-selection\\\/\",\"url\":\"https:\\\/\\\/expert-only.com\\\/en\\\/excel\\\/the-best-excel-shortcuts-for-selection\\\/\",\"name\":\"16 Best Excel Selection Shortcuts to Work Faster - Cheat Sheet\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/excel\\\/the-best-excel-shortcuts-for-selection\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/excel\\\/the-best-excel-shortcuts-for-selection\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/expert-only.com\\\/wp-content\\\/uploads\\\/2017\\\/08\\\/office-workspaces-colorful-C12F0EE24A6_1920x1080.jpeg\",\"datePublished\":\"2022-02-11T05:30:00+00:00\",\"dateModified\":\"2026-04-27T17:40:09+00:00\",\"description\":\"What are the best Excel shortcuts for selection? A selection of the most effective Excel shortcuts for making selections of cells and more.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/excel\\\/the-best-excel-shortcuts-for-selection\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/expert-only.com\\\/en\\\/excel\\\/the-best-excel-shortcuts-for-selection\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/excel\\\/the-best-excel-shortcuts-for-selection\\\/#primaryimage\",\"url\":\"https:\\\/\\\/expert-only.com\\\/wp-content\\\/uploads\\\/2017\\\/08\\\/office-workspaces-colorful-C12F0EE24A6_1920x1080.jpeg\",\"contentUrl\":\"https:\\\/\\\/expert-only.com\\\/wp-content\\\/uploads\\\/2017\\\/08\\\/office-workspaces-colorful-C12F0EE24A6_1920x1080.jpeg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/excel\\\/the-best-excel-shortcuts-for-selection\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\\\/\\\/expert-only.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"16 Best Excel Selection Shortcuts to Work Faster (Cheat Sheet)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/expert-only.com\\\/en\\\/\",\"name\":\"SQL Server and Data Courses\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/expert-only.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\\\/\\\/expert-only.com\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/expert-only.com\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\\\/\\\/expert-only.com\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/ExpertOnlyCom\\\/\",\"https:\\\/\\\/x.com\\\/expert_only\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#\\\/schema\\\/person\\\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e711e54a9f31bf0cc5e241d2149474e14ce3995669e683ae9e913aa93cd8da1?s=96&d=identicon&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e711e54a9f31bf0cc5e241d2149474e14ce3995669e683ae9e913aa93cd8da1?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e711e54a9f31bf0cc5e241d2149474e14ce3995669e683ae9e913aa93cd8da1?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"16 Best Excel Selection Shortcuts to Work Faster - Cheat Sheet","description":"What are the best Excel shortcuts for selection? A selection of the most effective Excel shortcuts for making selections of cells and more.","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:\/\/expert-only.com\/en\/excel\/the-best-excel-shortcuts-for-selection\/","og_locale":"en_US","og_type":"article","og_title":"16 Best Excel Selection Shortcuts to Work Faster (Cheat Sheet)","og_description":"What are the best Excel shortcuts for selection? A selection of the most effective Excel shortcuts for making selections of cells and more.","og_url":"https:\/\/expert-only.com\/en\/excel\/the-best-excel-shortcuts-for-selection\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-02-11T05:30:00+00:00","article_modified_time":"2026-04-27T17:40:09+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/office-workspaces-colorful-C12F0EE24A6_1920x1080.jpeg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/excel\/the-best-excel-shortcuts-for-selection\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/excel\/the-best-excel-shortcuts-for-selection\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"16 Best Excel Selection Shortcuts to Work Faster (Cheat Sheet)","datePublished":"2022-02-11T05:30:00+00:00","dateModified":"2026-04-27T17:40:09+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/excel\/the-best-excel-shortcuts-for-selection\/"},"wordCount":752,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/excel\/the-best-excel-shortcuts-for-selection\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/office-workspaces-colorful-C12F0EE24A6_1920x1080.jpeg","articleSection":["Excel Tips"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/excel\/the-best-excel-shortcuts-for-selection\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/excel\/the-best-excel-shortcuts-for-selection\/","url":"https:\/\/expert-only.com\/en\/excel\/the-best-excel-shortcuts-for-selection\/","name":"16 Best Excel Selection Shortcuts to Work Faster - Cheat Sheet","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/excel\/the-best-excel-shortcuts-for-selection\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/excel\/the-best-excel-shortcuts-for-selection\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/office-workspaces-colorful-C12F0EE24A6_1920x1080.jpeg","datePublished":"2022-02-11T05:30:00+00:00","dateModified":"2026-04-27T17:40:09+00:00","description":"What are the best Excel shortcuts for selection? A selection of the most effective Excel shortcuts for making selections of cells and more.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/excel\/the-best-excel-shortcuts-for-selection\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/excel\/the-best-excel-shortcuts-for-selection\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/excel\/the-best-excel-shortcuts-for-selection\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/office-workspaces-colorful-C12F0EE24A6_1920x1080.jpeg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/office-workspaces-colorful-C12F0EE24A6_1920x1080.jpeg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/excel\/the-best-excel-shortcuts-for-selection\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"16 Best Excel Selection Shortcuts to Work Faster (Cheat Sheet)"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL Server and Data Courses","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/7e711e54a9f31bf0cc5e241d2149474e14ce3995669e683ae9e913aa93cd8da1?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7e711e54a9f31bf0cc5e241d2149474e14ce3995669e683ae9e913aa93cd8da1?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7e711e54a9f31bf0cc5e241d2149474e14ce3995669e683ae9e913aa93cd8da1?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/5684","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=5684"}],"version-history":[{"count":1,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/5684\/revisions"}],"predecessor-version":[{"id":31144,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/5684\/revisions\/31144"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/5616"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=5684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=5684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=5684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}