{"id":386,"date":"2025-04-04T04:51:10","date_gmt":"2025-04-04T04:51:10","guid":{"rendered":"https:\/\/icacourse.icajobguarantee.com\/blog\/keyboard-shortcuts-for-ms-excel"},"modified":"2026-02-20T10:00:59","modified_gmt":"2026-02-20T10:00:59","slug":"keyboard-shortcuts-for-ms-excel","status":"publish","type":"post","link":"https:\/\/www.icacourse.in\/blog\/keyboard-shortcuts-for-ms-excel","title":{"rendered":"50+ Most Common Keyboard Shortcuts For Ms Excel"},"content":{"rendered":"<p>Do you want to know about the keyboard shortcuts for ms excel? If yes, then you must read this article to clarify your concepts from its core fundamentals. If you have to handle lots of data for your MS Excel then knowing the shortcut keys is mandatory. Otherwise, you cannot complete your work on time.<\/p>\n<p>In this blog, you will learn about the Excel shortcut keys that can bother you in the long run. It is one crucial fact that can make things happen in your way. Here, the application of the correct strategy can make things happen in your way.<\/p>\n<div class=\"block\">\n<h3>Table of Contents<\/h3>\n<ul>\n<li><a href=\"#1\">What Is Microsoft Excel?<\/a><\/li>\n<li><a href=\"#2\">The Need For Excel Shortcut Keys<\/a><\/li>\n<li><a href=\"#3\">Frequently Used Shortcut Keys<\/a><\/li>\n<li><a href=\"#4\">Ribbon Keyboard Shortcut Keys<\/a><\/li>\n<li><a href=\"#5\">Keyboard Shortcuts For Navigating In Cells<\/a><\/li>\n<li><a href=\"#6\">Formatting Short Keys In Excel<\/a><\/li>\n<li><a href=\"#7\">Frequently Asked Questions<\/a><\/li>\n<\/ul>\n<\/div>\n<p>Whether you are a pro in Excel or a beginner it does not matter but Keyboard shortcut keys that you will learn from this blog can guide you in the right direction.<\/p>\n<h2 id=\"1\">What Is Microsoft Excel?<\/h2>\n<p>Microsoft Excel is a powerful spreadsheet application that\u2019s part of the Microsoft Office suite of productivity software. It\u2019s designed to help users organize, analyze, and visualize data using a grid of cells arranged in rows and columns. Each cell can hold data like numbers, text, or formulas, and Excel provides a wide range of tools to manipulate that data\u2014think calculations, charts, pivot tables, and more.<\/p>\n<h2 id=\"2\">The Need For Excel Shortcut Keys<\/h2>\n<p>There are numerous reasons why you need to know about the Excel shortcut keys that are essential for your smooth workflow. In this article, you will get to know how knowing the shortcut keys in Excel can help you to work faster in all possible means.<\/p>\n<p>All these shortcut keys help the users to perform different kinds of tasks quickly along with improved efficiency. Additionally, you can do it with a single keystroke. It is essential for your spreadsheet masters. If you handle large amounts of datasets then it can save lots of time as well as it can boost your productivity. So, let\u2019s explore its importance one after the other.<\/p>\n<h3>1. Increases Speed &amp; Efficiency<\/h3>\n<p>Despite using all the functions mentioned in the menu all the Excel shortcut keys will help you to complete your task in just one click. Additionally, it can enhance your speed and efficiency. All these common Keyboard shortcut keys for MS excel can help you to meet your requirements with ease.<\/p>\n<h3>2. Improves Accuracy<\/h3>\n<p>All the shortcut keys can assist you in reducing the errors to a greater extent. You are likely to make fewer mistakes whenever you press while clicking through multiple menus.<\/p>\n<h3>3. Reduces Fatigue<\/h3>\n<p>When you make use of the shortcut keys then it reduces your need to reach for the mouse thus it reduces discomfort and fatigue to a considerable extent.<\/p>\n<h3>4. Enhances Workflow<\/h3>\n<p>You can easily streamline your work with the help of these shortcut keys to make your life easier in the workplace. So, these keyboard shortcut keys for Excel can make your life easier in the long run.<\/p>\n<h2>Complete List Of Keyboard Shortcuts For Ms Excel<\/h2>\n<p>There are several shortcut keys available in Excel that can make your life easier while you make use of these shortcut keys. So, let\u2019s explore them to have a clear insight into it.<\/p>\n<h2 id=\"3\">Frequently Used Shortcut Keys<\/h2>\n<div style=\"overflow-x: auto;\">\n<table class=\"table table-hover\">\n<thead>\n<tr>\n<th>SL No.<\/th>\n<th>Shortcut Keys<\/th>\n<th>Applications<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>1<\/td>\n<td>Ctrl +W<\/td>\n<td>This shortcut key is used to close the workbook<\/td>\n<\/tr>\n<tr>\n<td><strong>2<\/strong><\/td>\n<td>Ctrl +O<\/td>\n<td>For opening a workbook this shortcut key is used.<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>Alt +H<\/td>\n<td>You can go to the home Tab using this shortcut key.<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>Ctrl + S<\/td>\n<td>For saving a workbook<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>Ctrl +C<\/td>\n<td>You can copy the selection mail.<\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td>Ctrl +V<\/td>\n<td>For pasting the selection you can use this key<\/td>\n<\/tr>\n<tr>\n<td>7<\/td>\n<td>Ctrl +Z<\/td>\n<td>To undo the recent action<\/td>\n<\/tr>\n<tr>\n<td>8<\/td>\n<td>Delete<\/td>\n<td>For removing all the cell contents Delete option is used<\/td>\n<\/tr>\n<tr>\n<td>9<\/td>\n<td>Alt +H, H<\/td>\n<td>You can select the Fill Color with this option<\/td>\n<\/tr>\n<tr>\n<td>10<\/td>\n<td>Ctrl +X<\/td>\n<td>For cutting the selection you can make use of this key<\/td>\n<\/tr>\n<tr>\n<td>11<\/td>\n<td>Alt+N<\/td>\n<td>You can go to the Insert tab<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>Ctrl+B<\/td>\n<td>For the application of Bold formatting, it is used.<\/td>\n<\/tr>\n<tr>\n<td>13<\/td>\n<td>Alt +H, A,C<\/td>\n<td>You must center align all the cell contents.<\/td>\n<\/tr>\n<tr>\n<td>14<\/td>\n<td>Alt +P<\/td>\n<td>Go to the page layout tab<\/td>\n<\/tr>\n<tr>\n<td>15<\/td>\n<td>Alt +A<\/td>\n<td>You must go to the data tab<\/td>\n<\/tr>\n<tr>\n<td>16<\/td>\n<td>Alt + W<\/td>\n<td>To go to the view tab you must use it<\/td>\n<\/tr>\n<tr>\n<td>17<\/td>\n<td>Shift +F10 Or Windows Menu Key<\/td>\n<td>You must open the context menu<\/td>\n<\/tr>\n<tr>\n<td>18<\/td>\n<td>Alt +H, B<\/td>\n<td>Adding borders in your Excel sheet is possible with this key<\/td>\n<\/tr>\n<tr>\n<td>19<\/td>\n<td>Alt +H, D, C<\/td>\n<td>For deleting your column you can use this shortcut key<\/td>\n<\/tr>\n<tr>\n<td>20<\/td>\n<td>Alt +M<\/td>\n<td>You can go to the formula tab using this shortcut key<\/td>\n<\/tr>\n<tr>\n<td>21<\/td>\n<td>Ctrl+9<\/td>\n<td>For hiding all the selected rows this shortcut key you can make use off.<\/td>\n<\/tr>\n<tr>\n<td>22<\/td>\n<td>Ctrl +0<\/td>\n<td>If you want to hide the selected columns then you can make use of this shortcut key.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p><script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/image-map-resizer\/1.0.10\/js\/imageMapResizer.min.js\"><\/script><br \/>\n<script>window.onload = function() { imageMapResize(); }<\/script><br \/>\n<img decoding=\"async\" src=\"https:\/\/www.icacourse.in\/assets\/img\/blog\/excel-cta-banner-online.webp\" alt=\"Advanced MS Excel Course Online\" usemap=\"#image-map\" \/><\/p>\n<map name=\"image-map\">\n<area title=\"Advanced MS Excel Course (Online)\" alt=\"Advanced MS Excel Course (Online)\" coords=\"3,-1,835,370\" shape=\"rect\" href=\"https:\/\/www.icacourse.in\/courses\/advance-excel-course-online?utm_campaign=Excel_CTA&#038;utm_source=Blog\" target=\"_blank\" \/>\n<area title=\"Advanced MS Excel Course (Online)\" alt=\"Advanced MS Excel Course (Online)\" coords=\"357,403,483,428\" shape=\"rect\" href=\"https:\/\/www.icacourse.in\/courses\/advance-excel-course-online?utm_campaign=Excel_CTA&#038;utm_source=Blog\" target=\"_blank\" \/>\n<area title=\"Advanced MS Excel Course (Online)\" alt=\"Advanced MS Excel Course (Online)\" coords=\"488,402,626,430\" shape=\"rect\" href=\"https:\/\/www.icacourse.in\/courses\/advance-excel-course-online?utm_campaign=Excel_CTA&#038;utm_source=Blog\" target=\"_blank\" \/>\n<area title=\"Advanced Excel Course\" alt=\"Advanced Excel Course\" coords=\"635,403,771,430\" shape=\"rect\" href=\"https:\/\/www.icajobguarantee.com\/courses\/advanced-excel-course?utm_campaign=Excel_CTA&#038;utm_source=Blog\" target=\"_blank\" \/> <\/map>\n<h2 id=\"4\">Ribbon Keyboard Shortcut Keys<\/h2>\n<p>Ribbon keyboard shortcuts in Excel let you navigate and use the Ribbon\u2014the toolbar at the top with tabs like Home, Insert, and Data\u2014without touching your mouse. These shortcuts rely heavily on the <strong>Alt<\/strong> key to activate the Ribbon, followed by specific letters or numbers to drill down into commands. Here\u2019s how they work and the key ones to know.<\/p>\n<h3>How Ribbon Shortcuts Work?<\/h3>\n<ul>\n<li>Press <strong>Alt<\/strong>: This lights up the Ribbon with &#8220;KeyTips&#8221;\u2014little letters or numbers over each tab and command.<\/li>\n<li>Type the letter(s) for the tab you want (e.g., <strong>H<\/strong> for Home).<\/li>\n<li>Then type the letter(s) for the command (e.g., <strong>B<\/strong> for Bold).<\/li>\n<li>Some commands need a sequence (like <strong>Alt + H + O + I<\/strong> for auto-fit columns).<\/li>\n<\/ul>\n<p>There are certain access keys that you must know while you use these Ribbon keyboard shortcut keys for MS Excel. Let\u2019s go through the details to have a better understanding of it.<\/p>\n<div style=\"overflow-x: auto;\">\n<table class=\"table table-hover\">\n<thead>\n<tr>\n<th>SL No<\/th>\n<th>Shortcut Key<\/th>\n<th>Applications<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>23<\/td>\n<td>Alt +Q<\/td>\n<td>You can move to the Tell me or search field that are present in the ribbon or in the search term assistance to help the content.<\/td>\n<\/tr>\n<tr>\n<td>24<\/td>\n<td>Alt +F<\/td>\n<td>For opening the file menu you can make use of this shortcut key.<\/td>\n<\/tr>\n<tr>\n<td>25<\/td>\n<td>Alt +H<\/td>\n<td>You can make use of the home tab and the format text numbers to find the tool.<\/td>\n<\/tr>\n<tr>\n<td>26<\/td>\n<td>Alt +N<\/td>\n<td>Opening the insert tabs and inserting all the Pivot tables, add ins chart\u2019s , sparklines, pictures, shapes, text boxes, and headers you can open with this short cut key.<\/td>\n<\/tr>\n<tr>\n<td>27<\/td>\n<td>Alt +P<\/td>\n<td>You can easily use the Page layout tab and you can make use of Page set-up themes, alignment, and scale.<\/td>\n<\/tr>\n<tr>\n<td>28<\/td>\n<td>Alt +M<\/td>\n<td>With this shortcut key, you can open the formula&#8217;s key to insert, trace, customize, calculate, and function.<\/td>\n<\/tr>\n<tr>\n<td>29<\/td>\n<td>Alt + A<\/td>\n<td>You can open the data tab in order to sort, filter, and connect with all data tabs.<\/td>\n<\/tr>\n<tr>\n<td>30<\/td>\n<td>Alt +R<\/td>\n<td>Check spelling by opening the review tab along with it and add notes in threaded comments. Additionally, you can protect all the sheets by adding comments.<\/td>\n<\/tr>\n<tr>\n<td>31<\/td>\n<td>Alt +W<\/td>\n<td>You can open the view tab by previewing all the page breaks.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>You can work in the Ribbon with the application of Keyboard. Additionally, this can boost the scope of your brand development.<\/p>\n<h2 id=\"5\">Ribbon Keys With The Keyboard<\/h2>\n<p>There are several Ribbon Keys that you need to know while using the keyboard. Additionally, you cannot make your selection out of the dark. So, let\u2019s find out some of the crucial shortcut keys that you should look over from your end are as follows:-<\/p>\n<div style=\"overflow-x: auto;\">\n<table class=\"table table-hover\">\n<tbody>\n<tr>\n<th>SL No<\/th>\n<th>Shortcut Keys<\/th>\n<th>Applications<\/th>\n<\/tr>\n<tr>\n<td>32<\/td>\n<td>Alt +F10<\/td>\n<td>Alt + F10: Opens or closes the Selection Pane, a sidebar tool that lists all objects (shapes, charts, pictures, etc.) on the active worksheet.<\/td>\n<\/tr>\n<tr>\n<td>33<\/td>\n<td>Shieft +Tab<\/td>\n<td>It moves the focus or cursor <i>backward<\/i> through cells, fields, or dialog box elements, essentially the reverse of the <strong>Tab<\/strong> key.<\/td>\n<\/tr>\n<tr>\n<td>34<\/td>\n<td>Arrow Keys<\/td>\n<td>Arrow keys in Excel are simple but incredibly versatile, serving as your primary tool for navigation and selection on the keyboard. They move the active cell or cursor in the direction of the arrow\u2014up, down, left, or right\u2014and their applications expand with modifiers like <strong>Ctrl<\/strong>, <strong>Shift<\/strong>, or context-like editing.<\/td>\n<\/tr>\n<tr>\n<td>35<\/td>\n<td>Ctrl +Shieft +F10<\/td>\n<td>In a dataset, select A1:A5, hit <strong>Ctrl + Shift + F10<\/strong>, arrow to \u201cDelete,\u201d and remove cells.<\/td>\n<\/tr>\n<tr>\n<td>36<\/td>\n<td>Spacebar or Enter<\/td>\n<td>It will help you to activate the selected button<\/td>\n<\/tr>\n<tr>\n<td>37<\/td>\n<td>Down Arrow Key<\/td>\n<td>This will help you to open the selected command.<\/td>\n<\/tr>\n<tr>\n<td>38<\/td>\n<td>Alt + Down Arrow Key<\/td>\n<td>To open the menu for the selected button you must use this shortcut key.<\/td>\n<\/tr>\n<tr>\n<td>39<\/td>\n<td>Ctrl + F1<\/td>\n<td>It will open up the collapsed ribbon.<\/td>\n<\/tr>\n<tr>\n<td>40<\/td>\n<td>Shieft +F10<\/td>\n<td>If you want to open the context menu then Shieft +10 is used.<\/td>\n<\/tr>\n<tr>\n<td>41<\/td>\n<td>Left Arrow Key<\/td>\n<td>You can move to the sub menu when the main menu is selected and open.<\/td>\n<\/tr>\n<tr>\n<td>42<\/td>\n<td>Ctrl + Left or Right Arrow Key<\/td>\n<td>It can help you to move from one group of controls to another.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"blockquote\">\n<p>Checkout some articles related to Online BBA :<\/p>\n<ul>\n<li><a href=\"https:\/\/www.icacourse.in\/shobhit-online\/is-an-online-bba-valid-in-india\" target=\"_blank\" rel=\"noopener\">Is Online BBA Valid in India?<\/a><\/li>\n<li><a href=\"https:\/\/www.icacourse.in\/shobhit-online\/ica-edu-skills-shobhit-university-bba-valid\" target=\"_blank\" rel=\"noopener\">Is the ICA Edu Skills &amp; Shobhit University BBA Valid?<\/a><\/li>\n<li><a href=\"https:\/\/www.icacourse.in\/shobhit-online\/get-a-govt-job-with-an-online-bba\" target=\"_blank\" rel=\"noopener\">Can You Really Get a Govt Job with an Online BBA?<\/a><\/li>\n<li><a href=\"https:\/\/www.icacourse.in\/shobhit-online\/what-are-online-bba-degrees-in-india\" target=\"_blank\" rel=\"noopener\">What are Online BBA degrees in India?<\/a><\/li>\n<\/ul>\n<\/div>\n<h2 id=\"6\">Keyboard Shortcuts For Navigating In Cells<\/h2>\n<p>Navigation keys in Excel are essential for moving around a worksheet efficiently without relying heavily on the mouse. They help you select cells, edit data, and navigate large datasets quickly. These are the most important Keyboard shortcut keys for MS Excel that you should know from your end.<\/p>\n<div style=\"overflow-x: auto;\">\n<table class=\"table table-hover\">\n<thead>\n<tr>\n<td>SL No<\/td>\n<td>Shortcut Key<\/td>\n<td>Applications<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>43<\/td>\n<td>Shift + Tab<\/td>\n<td>When you press <strong>Shift + Tab<\/strong>, the active cell moves one cell to the left in the same row. If you&#8217;re at the first column of a row (e.g., column A), pressing <strong>Shift + Tab<\/strong> will move the active cell to the last column of the previous row (e.g., from A2 to the last cell in row 1).<\/td>\n<\/tr>\n<tr>\n<td>44<\/td>\n<td>Up Arrow Key<\/td>\n<td>Pressing the <strong>Up Arrow<\/strong> key moves the active cell one cell upward in the same column.<\/p>\n<p>For example, if the active cell is <strong>B5<\/strong>, pressing <strong>Up Arrow<\/strong> moves it to <strong>B4<\/strong>. If you\u2019re already in row 1 (e.g., <strong>B1<\/strong>), it won\u2019t move further up.<\/td>\n<\/tr>\n<tr>\n<td>45<\/td>\n<td>Down Arrow Key<\/td>\n<td>Pressing the <strong>Down Arrow<\/strong> key moves the active cell one cell downward in the same column.<\/p>\n<p>For example, if the active cell is <strong>B5<\/strong>, pressing <strong>Down Arrow<\/strong> moves it to <strong>B6<\/strong>.<\/td>\n<\/tr>\n<tr>\n<td>46<\/td>\n<td>Left Arrow Key<\/td>\n<td>Pressing the <strong>Left Arrow<\/strong> key moves the active cell one cell to the left in the same row.<\/p>\n<p>For example, if the active cell is <strong>C5<\/strong>, pressing <strong>Left Arrow<\/strong> moves it to <strong>B5<\/strong>. If you\u2019re in the first column (e.g., <strong>A5<\/strong>), it won\u2019t move further left.<\/td>\n<\/tr>\n<tr>\n<td>47<\/td>\n<td>Right Arrow Key<\/td>\n<td>Pressing the <strong>Right Arrow<\/strong> key moves the active cell one cell to the right in the same row.<\/p>\n<p>For example, if the active cell is <strong>B5<\/strong>, pressing <strong>Right Arrow<\/strong> moves it to <strong>C5<\/strong>. If you\u2019re in the last column (e.g., <strong>XFD5<\/strong> in modern Excel versions), it won\u2019t move further right.<\/td>\n<\/tr>\n<tr>\n<td>48<\/td>\n<td>Ctrl + Arrow Key<\/td>\n<td>In Excel, <strong>Ctrl + Arrow Key<\/strong> is used for quick navigation within a worksheet<\/td>\n<\/tr>\n<tr>\n<td>49<\/td>\n<td>Ctrl + End<\/td>\n<td>Moves the cursor to the <strong>last used cell<\/strong> in the worksheet (i.e., the intersection of the last used row and the last used column).<\/td>\n<\/tr>\n<tr>\n<td>50<\/td>\n<td>Ctrl +Shieft + End<\/td>\n<td>Selects all cells from the current cell to the last used cell (determined by Ctrl + End). If your cursor is in A1 and you press Ctrl + Shift + End, it selects everything from A1 to the last used cell in the worksheet.<\/td>\n<\/tr>\n<tr>\n<td>51<\/td>\n<td>Home + Scroll Lock<\/td>\n<td>In Excel, pressing <strong>Home + Scroll Lock<\/strong> modifies navigation within the spreadsheet. When <strong>Scroll Lock<\/strong> is enabled, the arrow keys scroll the worksheet without changing the active cell (the selected cell remains static). Adding the <strong>Home<\/strong> key to the combination moves the view back to the beginning of the row, while still keeping the Scroll Lock functionality active.<\/td>\n<\/tr>\n<tr>\n<td>52<\/td>\n<td>Ctrl + Home<\/td>\n<td>In Excel, pressing <strong>Ctrl + Home<\/strong> is a quick way to navigate to the very beginning of your worksheet. Specifically, it moves the selection to cell <strong>A1<\/strong> (the first cell of the sheet) or to the first cell with data if the worksheet is frozen with panes.<\/p>\n<p>This shortcut is especially helpful when you&#8217;re working with large datasets and need to return to the top quickly.<\/td>\n<\/tr>\n<tr>\n<td>53<\/td>\n<td>Page Down<\/td>\n<td>It moves one screen down to the worksheet.<\/td>\n<\/tr>\n<tr>\n<td>54<\/td>\n<td>Ctrl + Page Down<\/td>\n<td>In Excel, pressing <strong>Ctrl + Page Down<\/strong> allows you to quickly navigate between worksheets within the workbook. Specifically, this shortcut moves you to the next worksheet to the right in the workbook tabs.<\/td>\n<\/tr>\n<tr>\n<td>55<\/td>\n<td>Alt + Page Down<\/td>\n<td>Alt + Page Down is used for horizontal navigation within a worksheet.<\/td>\n<\/tr>\n<tr>\n<td>56<\/td>\n<td>Page Up<\/td>\n<td>In Excel, pressing <strong>Page Up<\/strong> moves your view <strong>upward by one screen<\/strong> in the current worksheet. If you&#8217;re working with a large dataset, this shortcut allows you to scroll up quickly without using the mouse or dragging the scrollbar. It doesn\u2019t change the selected cell; it just shifts the view.<\/td>\n<\/tr>\n<tr>\n<td>57<\/td>\n<td>Alt + Page Up<\/td>\n<td>Alt + Page Up shifts the view <strong>one screen to the left<\/strong>, similar to scrolling sideways in the worksheet. It&#8217;s particularly useful when dealing with wide spreadsheets, as it allows you to quickly navigate horizontally without losing sight of the active cell.<\/td>\n<\/tr>\n<tr>\n<td>58<\/td>\n<td>Ctrl + Page Up<\/td>\n<td>It helps to move from the previous sheet to the workbook.<\/td>\n<\/tr>\n<tr>\n<td>59<\/td>\n<td>Tab Key<\/td>\n<td>In Excel, the Tab key is used to move the selection one cell to the right within a row. It&#8217;s helpful for navigating horizontally, especially when entering data across columns. When you reach the last column of a table or data range, pressing Tab can take you to the first cell of the next row.<\/td>\n<\/tr>\n<tr>\n<td>60<\/td>\n<td>Alt + Down Arrow Key<\/td>\n<td>Alt + Down Arrow opens the drop-down list for a selected cell if it contains data validation or is part of a filter. This shortcut is particularly helpful for quickly accessing options within a dropdown menu, such as selecting from predefined choices or filtering data in a table.<\/td>\n<\/tr>\n<tr>\n<td>61<\/td>\n<td>Ctrl + Alt +5<\/td>\n<td>The Ctrl + Alt + 5 shortcut activates the &#8220;Print Preview&#8221; feature. This allows you to quickly view how your worksheet will look when printed, helping you check formatting, layout, and any potential issues before sending it to the printer.<\/td>\n<\/tr>\n<tr>\n<td>62<\/td>\n<td>Esc<\/td>\n<td>The <strong>Esc (Escape) key<\/strong> in Excel is primarily used for navigation and canceling actions.<\/td>\n<\/tr>\n<tr>\n<td>63<\/td>\n<td>Ctrl + Shift<\/td>\n<td>Ctrl + Shift is used in combination with other keys for navigation and selection.<\/td>\n<\/tr>\n<tr>\n<td>64<\/td>\n<td>Ctrl + Alt + Equal(=)<\/td>\n<td>In Excel, Ctrl + Alt + = (Equal key) is used for quickly inserting the SUM function or you can Zoom in with this function.<\/td>\n<\/tr>\n<tr>\n<td>65<\/td>\n<td>Ctrl + Alt + Minus(-)<\/td>\n<td>For zooming out Ctrl + Alt + Minus key is used.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h2 id=\"7\">Formatting Short Keys In Excel<\/h2>\n<p>There are several formatting shortcut keys in Excel that you should know from your end while handling large amounts of Datasheets. Now the core functions of the formatting keyboard shortcut keys for MS Excel are as follows:-<\/p>\n<div style=\"overflow-x: auto;\">\n<table class=\"table table-hover\">\n<thead>\n<tr>\n<th>SL No<\/th>\n<th>Short Cut Keys<\/th>\n<th>Applications<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>66<\/td>\n<td>Ctrl + B<\/td>\n<td>Bold the selected text or cells.<\/td>\n<\/tr>\n<tr>\n<td>67<\/td>\n<td>Ctrl + I<\/td>\n<td>Italicize the selected text or cells.<\/td>\n<\/tr>\n<tr>\n<td>68<\/td>\n<td>Ctrl + U<\/td>\n<td>Underline the selected text or cells.<\/td>\n<\/tr>\n<tr>\n<td>69<\/td>\n<td>Ctrl + 1<\/td>\n<td>Open the &#8220;Format Cells&#8221; dialog box for more detailed formatting options.<\/td>\n<\/tr>\n<tr>\n<td>70<\/td>\n<td>Ctrl + Shift + &amp;<\/td>\n<td>Apply borders around the selected cells.<\/td>\n<\/tr>\n<tr>\n<td>71<\/td>\n<td>Ctrl + Shift + _ (underscore)<\/td>\n<td>Remove borders from the selected cells.<\/td>\n<\/tr>\n<tr>\n<td>72<\/td>\n<td>Alt + H + H<\/td>\n<td>Open the fill color menu to change the background color of cells.<\/td>\n<\/tr>\n<tr>\n<td>73<\/td>\n<td>Alt + H + B<\/td>\n<td>Add borders to cells via the &#8220;Borders&#8221; menu.<\/td>\n<\/tr>\n<tr>\n<td>74<\/td>\n<td>Ctrl + Shift + $<\/td>\n<td>Apply currency formatting to numbers.<\/td>\n<\/tr>\n<tr>\n<td>75<\/td>\n<td>Ctrl + Shift + %<\/td>\n<td>Make applications of percentage formatting to numbers.<\/td>\n<\/tr>\n<tr>\n<td>76<\/td>\n<td>Ctrl + Shift + #<\/td>\n<td>Apply date formatting to numbers.<\/td>\n<\/tr>\n<tr>\n<td>77<\/td>\n<td>Ctrl + Shift + ^<\/td>\n<td>Making applications of exponential (scientific) format.<\/td>\n<\/tr>\n<tr>\n<td>78<\/td>\n<td>Ctrl + Shift + ~<\/td>\n<td>Apply general formatting to remove specific formats.<\/td>\n<\/tr>\n<tr>\n<td>79<\/td>\n<td>Ctrl+K<\/td>\n<td>Ctrl + K opens the <strong>Insert Hyperlink<\/strong> dialog box. This shortcut allows you to quickly add a hyperlink to the selected cell or text.<\/td>\n<\/tr>\n<tr>\n<td>80<\/td>\n<td>Ctrl+Q<\/td>\n<td>In Excel, <strong>Ctrl + Q<\/strong> opens the <strong>Quick Analysis Tool<\/strong> for selected cells.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>These are some of the crucial common keyboard shortcut keys for MS Excel that you must know from your end.<\/p>\n<h2 id=\"7\">Frequently Asked Questions<\/h2>\n<h3>1. What Are The Most Frequently Used Keyboard Shortcut Keys For MS Excel?<\/h3>\n<p>Some of the most frequently used shortcuts include:<\/p>\n<ul>\n<li><strong>Ctrl + C<\/strong> \u2192 Copy<\/li>\n<li><strong>Ctrl + V<\/strong> \u2192 Paste<\/li>\n<li><strong>Ctrl + X<\/strong> \u2192 Cut<\/li>\n<li><strong>Ctrl + Z<\/strong> \u2192 Undo<\/li>\n<li><strong>Ctrl + S<\/strong> \u2192 Save<\/li>\n<\/ul>\n<h3>2. How Can You Quickly Navigate Large Datasets Using Keyboard Shortcut Keys In MS Excel?<\/h3>\n<p>You can use these shortcuts for fast navigation:<\/p>\n<ul>\n<li><strong>Ctrl + Arrow Keys<\/strong> \u2192 Move to the last filled cell in a row\/column<\/li>\n<li><strong>Ctrl + Home<\/strong> \u2192 Go to cell A1<\/li>\n<li><strong>Ctrl + End<\/strong> \u2192 Jump to the last used cell<\/li>\n<li><strong>Alt + Page Down<\/strong> \u2192 Scroll one screen right<\/li>\n<li><strong>Alt + Page Up<\/strong> \u2192 Scroll one screen left<\/li>\n<\/ul>\n<h3>3. What Are The Shortcut Keys For Selecting Data In MS Excel?<\/h3>\n<p>For quick selection:<\/p>\n<ul>\n<li><strong>Ctrl + Shift + Arrow Keys<\/strong> \u2192 Select data up to the last filled cell<\/li>\n<li><strong>Ctrl + Shift + End<\/strong> \u2192 Select from current cell to the last used cell<\/li>\n<li><strong>Ctrl + Shift + Home<\/strong> \u2192 Select from current cell to A1<\/li>\n<li><strong>Shift + Space<\/strong> \u2192 Select the entire row<\/li>\n<li><strong>Ctrl + Space<\/strong> \u2192 Select the entire column<\/li>\n<\/ul>\n<h3>4. How Can You Insert Or Delete Rows And Columns Using Keyboard Shortcuts In MS Excel?<\/h3>\n<p>You can use the following shortcuts:<\/p>\n<ul>\n<li><strong>Ctrl + &#8220;+&#8221; (Plus Key)<\/strong> \u2192 Insert a new row\/column<\/li>\n<li><strong>Ctrl + &#8220;-&#8221; (Minus Key)<\/strong> \u2192 Delete a selected row\/column<\/li>\n<li><strong>Ctrl + Shift + &#8220;=&#8221;<\/strong> \u2192 Insert a new cell<\/li>\n<li><strong>Ctrl + Shift + &#8220;-&#8220;<\/strong> \u2192 Delete a selected cell<\/li>\n<\/ul>\n<h3>5. What Is The Shortcut Key For AutoSum And Applying Formulas Quickly In MS Excel?<\/h3>\n<ul>\n<li><strong>Ctrl + Alt + =<\/strong> \u2192 Automatically inserts the SUM function (=SUM(&#8230;)).<\/li>\n<li><strong>Alt + =<\/strong> \u2192 Also works for AutoSum in selected cells.<\/li>\n<li><strong>Ctrl + Enter<\/strong> \u2192 Apply the same formula to all selected cells.<\/li>\n<\/ul>\n<div class=\"blockquote\">\n<p>Few insightful articles on Excel to improve your knowledge:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.icacourse.in\/blog\/data-visualization-in-excel\" target=\"_blank\" rel=\"noopener\">Mastering Data Visualization In Excel: A Complete Guide<\/a><\/li>\n<li><a href=\"https:\/\/www.icajobguarantee.com\/blog\/flash-fill-in-excel\" target=\"_blank\" rel=\"noopener\">Mastering Flash Fill In Excel: A Comprehensive Tutorial<\/a><\/li>\n<li><a href=\"https:\/\/www.icajobguarantee.com\/blog\/data-visualization-in-excel\" target=\"_blank\" rel=\"noopener\">Data Visualization in Excel: Creating Impactful Visuals<\/a><\/li>\n<li><a href=\"https:\/\/www.icajobguarantee.com\/blog\/15-advanced-excel-formulas\" target=\"_blank\" rel=\"noopener\">15+ Advanced Excel Formulas: Learn to Become an Excel Pro<\/a><\/li>\n<li><a href=\"https:\/\/www.icajobguarantee.com\/blog\/top-25-shortcut-keys-for-excel\" target=\"_blank\" rel=\"noopener\">Top 25+ Shortcut Keys For Excel: Work Like A Pro<\/a><\/li>\n<\/ul>\n<\/div>\n<h2>Final Take Away<\/h2>\n<p>Hence, these are some of the crucial keyboard shortcut keys for excel that you can make use off from your end. Ensure that you follow the correct solution from your end while meeting your requirements with ease.<\/p>\n<p>You can share your views and opinions in our comment box. This will help us to know your opinion in this regard. Here. proper planning is the key to meeting your needs with complete ease.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Do you want to know about the keyboard shortcuts for ms excel? If yes, then you must read this article to clarify your concepts from its core fundamentals. If you have to handle lots of data for your MS Excel then knowing the shortcut keys is mandatory. Otherwise, you cannot complete your work on time. [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":387,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-386","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.icacourse.in\/blog\/wp-json\/wp\/v2\/posts\/386","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.icacourse.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.icacourse.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.icacourse.in\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.icacourse.in\/blog\/wp-json\/wp\/v2\/comments?post=386"}],"version-history":[{"count":7,"href":"https:\/\/www.icacourse.in\/blog\/wp-json\/wp\/v2\/posts\/386\/revisions"}],"predecessor-version":[{"id":1701,"href":"https:\/\/www.icacourse.in\/blog\/wp-json\/wp\/v2\/posts\/386\/revisions\/1701"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.icacourse.in\/blog\/wp-json\/wp\/v2\/media\/387"}],"wp:attachment":[{"href":"https:\/\/www.icacourse.in\/blog\/wp-json\/wp\/v2\/media?parent=386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.icacourse.in\/blog\/wp-json\/wp\/v2\/categories?post=386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.icacourse.in\/blog\/wp-json\/wp\/v2\/tags?post=386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}