{"id":913,"date":"2018-08-29T17:06:54","date_gmt":"2018-08-29T07:06:54","guid":{"rendered":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?p=913"},"modified":"2026-02-18T15:17:27","modified_gmt":"2026-02-18T04:17:27","slug":"28-must-know-excel-keyboard-shortcuts-tutorial-2018","status":"publish","type":"post","link":"https:\/\/www.dynamicwebtraining.com.au\/blog\/28-must-know-excel-keyboard-shortcuts-tutorial-2018","title":{"rendered":"28 Must Know Excel Keyboard Shortcuts – Tutorial 2018"},"content":{"rendered":"\n

For those of you who are required to work on Microsoft Excel spreadsheets on a daily basis, a list of Excel shortcuts can save you around 2 seconds per minute(8 working days per year). Yes, you heard it right!!
While every new version of Excel comes with new shortcuts, there are only about 20 \u2013 30 keyboard shortcuts usually needed to sufficing everyday office work. Rests are typically used for advanced tasks.<\/p>\n\n\n\n\n\n\n\n

\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Microsoft Excel: keyboard shortcuts<\/h2>\n\n\n\n

So, go on to become Microsoft Excel masters with the most useful Excel keyboard shortcuts you would want to bookmark:<\/p>\n\n\n\n

Ctrl + n<\/h4>\n\n\n\n

It is one of the most useful yet uncommon shortcuts when working in any software like Excel for that matter. The command allows you to create a new file or workbook<\/strong> in Excel instantly. It can prove extremely handy when you are looking to paste copied data from one worksheet to a new worksheet.<\/p>\n\n\n\n

Ctrl + o<\/h4>\n\n\n\n

Just like Ctrl + N<\/em><\/strong> allow you to open a new workbook<\/strong>; the Ctrl + o<\/em> <\/strong>keyboard shortcut lets you open an existing workbook. It is known to many, yet people click the File tab to open a workbook. Remember, you make a fraction of a difference, but at the end of the day, you end up saving 10 to 15 minutes for yourself.<\/p>\n\n\n\n

Ctrl + \u2193<\/h4>\n\n\n\n

It can be a tedious task to manually scroll down to the end of the column in an Excel spreadsheet with a long list of data. Using Ctrl with downward arrow key (\u2193) can take you directly to the end of the column<\/strong> within seconds. Now how many of you knew that?<\/p>\n\n\n\n

Ctrl + \u2191<\/h4>\n\n\n\n

Just like using Ctrl with downward arrow key can take you to the end of the column, using Ctrl with upward arrow key (\u2191) can help you jump right to the top of the column<\/strong>.<\/p>\n\n\n\n

Ctrl + Tab<\/h4>\n\n\n\n

There are times when you are required to refer to the next open worksheet for some data, and you have to toggle between the 2 active worksheets<\/strong> constantly. At such times, using the Ctrl +Tab shortcut can save you from manually looking up for the next open worksheet.<\/p>\n\n\n\n

Ctrl + w<\/h4>\n\n\n\n

This shortcut key allows you to instantly close an active workbook<\/strong> so that you do not need to look closely for the \u201cX\u201d mark on a corner of your worksheet to close it.<\/p>\n\n\n\n

Ctrl + 1<\/h4>\n\n\n\n

This shortcut command instantly opens the \u201cFormat Cells<\/em><\/strong>\u201d dialogue box, allowing you to format information contained in cells on the go.<\/p>\n\n\n\n

\n
\"Fig-01
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Shift + F11<\/h4>\n\n\n\n

Quickly insert a new blank sheet<\/strong> with this handy Excel shortcut and continue working without any disruption. Mind you, it has a Shift and not a Ctrl.<\/p>\n\n\n\n

Shift + F2<\/h4>\n\n\n\n

Want to add comments<\/strong> to the cell for others to refer, as you work through the worksheet? The Shift + F2<\/em><\/strong> Excel shortcut allows you to do just that.<\/p>\n\n\n\n

\n
\"Fig-02-Shift
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Ctrl + d<\/h4>\n\n\n\n

Forget the age-old technique of first copying desired cell value and then pasting it to the next cell. Simply use Ctrl + d<\/em> <\/strong>to fill the selected cell with the same value as the cell above it<\/strong>.<\/p>\n\n\n\n

\n
\"Fig-03-Ctrl
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Ctrl + r<\/h4>\n\n\n\n

Use this Excel shortcut to fill the selected cell with the same value as the cell to the left of it<\/strong>.<\/p>\n\n\n\n

\n
\"Fig-04
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Ctrl + Shift + %<\/h4>\n\n\n\n

Show the selected value in percentage form<\/strong> with this simple Excel keyboard shortcut.<\/p>\n\n\n\n

\n
\"Fig-05
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Ctrl + ; (Semicolon)<\/h4>\n\n\n\n

This shortcut command lets you insert current date<\/strong>.<\/p>\n\n\n\n

\n
\"Fig-06
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Ctrl + Shift + : (Colon)<\/h4>\n\n\n\n

This shortcut command lets you insert current time<\/strong>.<\/p>\n\n\n\n

\n
\"Fig-07
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Ctrl + T<\/h4>\n\n\n\n

Easily convert selected cells into a table<\/strong> with this Excel shortcut.<\/p>\n\n\n\n

\n
\"Fig-08
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Ctrl + Spacebar<\/h4>\n\n\n\n

You no more need to scroll down manually to select an entire column<\/strong>. Simply use Ctrl + Spacebar<\/em><\/strong> to select the column till the end.<\/p>\n\n\n\n

\n
\"Fig-09
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Shift + Spacebar<\/h4>\n\n\n\n

Similarly, select an entire row<\/strong> right till the end with this simple Excel shortcut.<\/p>\n\n\n\n

\n
\"Fig-10
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Ctrl + End<\/h4>\n\n\n\n

This Excel shortcut lets you reach to the end of your worksheet<\/strong> in a flash.<\/p>\n\n\n\n

Ctrl + Home<\/h4>\n\n\n\n

This Excel shortcut lets you move right to the beginning of your worksheet<\/strong> in a flash.<\/p>\n\n\n\n

F7<\/h4>\n\n\n\n

This quick Excel command allows you to check your grammar and spellings<\/strong> on the go, by opening the spelling and grammar dialogue box.<\/p>\n\n\n\n

\n
\"Fig-11
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Ctrl + Shift + &<\/h4>\n\n\n\n

This Excel shortcut lets you quickly apply outline border to your selected cells<\/strong>, to make them stand out in your Excel spreadsheet.<\/p>\n\n\n\n

\n
\"Fig-12
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Ctrl + Shift + – (minus)<\/h4>\n\n\n\n

Quickly remove borders<\/strong> around cells with this Excel keyboard shortcut.<\/p>\n\n\n\n

Ctrl + F<\/h4>\n\n\n\n

It can be a herculean task to look for specific data when you have a huge pool of data. At such times, simply using Ctrl + F<\/em> shortcut will open the \u201cFind& Replace<\/em>\u201d dialog box, allowing you to find and\/or replace required data in a flash.<\/p>\n\n\n\n

\n
\"Fig-13
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

F12<\/h4>\n\n\n\n

Wish to save your active workbook<\/strong> in a new name on the go? Directly, hit the F12 key, and the \u201cSave as<\/em>\u201d dialogue box opens up.<\/p>\n\n\n\n

\n
\"Fig-14
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Ctrl + Shift + L<\/h4>\n\n\n\n

This is an excellent shortcut that allows you to apply and clear filters<\/strong> within seconds. Just use the command twice to toggle filters<\/strong>. This handy shortcut is the easiest way to reset your table that may be containing several filters applied.<\/p>\n\n\n\n

\n
\"Fig-15
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Ctrl + `<\/h4>\n\n\n\n

It is the fastest way to reveal (temporarily) all the formulas<\/strong> that you have applied in your worksheet. So, now toggle formulas on and off on the Go!!<\/p>\n\n\n\n

\n
\"Fig-16
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Alt + =<\/h4>\n\n\n\n

You no more need to struggle with your Excel worksheet to look for the Sum function<\/strong>. This magical Excel shortcut automatically inserts the \u201cSum\u201d function, allowing you to Autosum<\/strong> columns, rows or even entire table at one go.<\/p>\n\n\n\n

\n
\"Fig-17
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Ctrl + Alt + V + (Transpose)<\/h4>\n\n\n\n

You do not need to panic after pasting data into columns that were meant to be pasted in a row. Instead of manually cutting and pasting one data at a time from column to its correct position in the row, select the cell where you need the data and use the Ctrl + Alt + V<\/em><\/strong> shortcut command to open the \u201cpaste special<\/strong>\u201d dialogue box.<\/p>\n\n\n\n

\n
\"Fig-18
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Select \u201cTranspose<\/em><\/strong>\u201d checkbox right at the bottom of the box, to flip a selected column of data to a row!!<\/p>\n\n\n\n

\n
\"Fig-18
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Excel shortcuts can be a vital weapon, if you wish to make working on Excel a faster, easier and error-free experience!!<\/p>\n\n\n\n

If you’re struggling with the basics, enrolling in an instructor-led Excel Beginner course<\/a><\/strong> can set you up for success. To truly master the fundamentals, we recommend our highly-rated Microsoft Excel Training Courses<\/a><\/strong> available in-person or online live.<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

For those of you who are required to work on Microsoft Excel spreadsheets on a daily basis, a list of Excel shortcuts can save you around 2 seconds per minute(8 working days per year). Yes, you heard it right!!While every new version of Excel comes with new shortcuts, there are only about 20 \u2013 30…<\/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-913","post","type-post","status-publish","format-standard","hentry","category-microsoft-excel"],"yoast_head":"28 Must Know Excel Keyboard Shortcuts - Tutorial 2018<\/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\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" 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\/28-must-know-excel-keyboard-shortcuts-tutorial-2018\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"28 Must Know Excel Keyboard Shortcuts - Tutorial 2018\" \/>\n<meta property=\"og:description\" content=\"Become Microsoft Excel master with most useful Excel keyboard shortcuts which can help save you around 2 seconds per minute.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/28-must-know-excel-keyboard-shortcuts-tutorial-2018\" \/>\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=\"2018-08-29T07:06:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-18T04:17:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/08\/Excel-Keyboard-Shortcuts.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:creator\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:site\" content=\"@dynamicwebtrain\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\",\"name\":\"Dynamic Web Training\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/DynamicWebTraining\/\",\"https:\/\/www.linkedin.com\/company\/dynamic-web-training\",\"https:\/\/twitter.com\/dynamicwebtrain\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png\",\"width\":361,\"height\":109,\"caption\":\"Dynamic Web Training\"},\"image\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#logo\"}},{\"@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\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/28-must-know-excel-keyboard-shortcuts-tutorial-2018#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/08\/Excel-Keyboard-Shortcuts.jpg\",\"width\":1200,\"height\":628},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/28-must-know-excel-keyboard-shortcuts-tutorial-2018#webpage\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/28-must-know-excel-keyboard-shortcuts-tutorial-2018\",\"name\":\"28 Must Know Excel Keyboard Shortcuts - Tutorial 2018\",\"isPartOf\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/28-must-know-excel-keyboard-shortcuts-tutorial-2018#primaryimage\"},\"datePublished\":\"2018-08-29T07:06:54+00:00\",\"dateModified\":\"2026-02-18T04:17:27+00:00\",\"description\":\"Become Microsoft Excel master with most useful Excel keyboard shortcuts which can help save you around 2 seconds per minute.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/28-must-know-excel-keyboard-shortcuts-tutorial-2018#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dynamicwebtraining.com.au\/blog\/28-must-know-excel-keyboard-shortcuts-tutorial-2018\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/28-must-know-excel-keyboard-shortcuts-tutorial-2018#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\",\"name\":\"Training Blog\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\",\"name\":\"Training\"}},{\"@type\":\"ListItem\",\"position\":3,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/microsoft-excel\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/microsoft-excel\",\"name\":\"Microsoft Excel\"}},{\"@type\":\"ListItem\",\"position\":4,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/28-must-know-excel-keyboard-shortcuts-tutorial-2018\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/28-must-know-excel-keyboard-shortcuts-tutorial-2018\",\"name\":\"28 Must Know Excel Keyboard Shortcuts – Tutorial 2018\"}}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/28-must-know-excel-keyboard-shortcuts-tutorial-2018#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/28-must-know-excel-keyboard-shortcuts-tutorial-2018#webpage\"},\"author\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233\"},\"headline\":\"28 Must Know Excel Keyboard Shortcuts – Tutorial 2018\",\"datePublished\":\"2018-08-29T07:06:54+00:00\",\"dateModified\":\"2026-02-18T04:17:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/28-must-know-excel-keyboard-shortcuts-tutorial-2018#webpage\"},\"publisher\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/28-must-know-excel-keyboard-shortcuts-tutorial-2018#primaryimage\"},\"articleSection\":\"Microsoft Excel\",\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233\",\"name\":\"Dynamic Web Training\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"caption\":\"Dynamic Web Training\"},\"description\":\"Dynamic Web Training is Australia's leading provider of instructor led software training. We offer training courses in Adobe, Web Design, Graphic Design, Photoshop, InDesign, Dreamweaver and many more.\",\"sameAs\":[\"https:\/\/www.facebook.com\/DynamicWebTraining\/\",\"https:\/\/www.linkedin.com\/company\/dynamic-web-training\",\"https:\/\/twitter.com\/dynamicwebtrain\"]}]}<\/script>","_links":{"self":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/913","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=913"}],"version-history":[{"count":9,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/913\/revisions"}],"predecessor-version":[{"id":2379,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/913\/revisions\/2379"}],"wp:attachment":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/media?parent=913"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/categories?post=913"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/tags?post=913"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}