{"id":25555973,"date":"2023-03-11T20:00:15","date_gmt":"2023-03-11T14:30:15","guid":{"rendered":"https:\/\/entri.app\/blog\/?p=25555973"},"modified":"2023-03-11T18:03:03","modified_gmt":"2023-03-11T12:33:03","slug":"keyboard-shortcuts-in-excel","status":"publish","type":"post","link":"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/","title":{"rendered":"Keyboard Shortcuts in Excel for Data Entry"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_79_2 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a03d5225c7d8\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a03d5225c7d8\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#What_is_MS_Excel\" >What is MS Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#Need_for_Excel_Shortcuts\" >Need for Excel Shortcuts<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#Benefits_of_Using_keyboard_Shortcuts\" >Benefits of Using keyboard Shortcuts<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#Keyboard_Shortcuts_in_Excel_for_Data_Entry\" >Keyboard Shortcuts in Excel for Data Entry<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#Conclusion\" >Conclusion<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#FAQs\" >FAQs<\/a><\/li><\/ul><\/nav><\/div>\n<p>Microsoft Excel\u00a0is extensively used across the globe to store and\u00a0analyze data. Despite various new data analytics tools in the market, Excel remains the go-to product for working with data. It has numerous in-built features, which makes it easier for you to organize your data.<\/p>\n<p>The shortcut keys in\u00a0Excel help you work on your data\u00a0in a jiffy. In this article, we\u2019ll be discussing the various Excel shortcuts. These keyboard shortcuts are used to perform tasks faster and effectively.<\/p>\n<p style=\"text-align: center\"><strong><a href=\"https:\/\/entri.app\/course\/data-science-and-machine-learning-course\/\" target=\"_blank\" rel=\"noopener\">\u00a0 Looking for a Data science and Machine learning Career? Explore Here!!<\/a><\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"What_is_MS_Excel\"><\/span><b>What is MS Excel?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>MS Excel is a spreadsheet program where one can record data in the form of tables. It is easy to analyse data in an Excel spreadsheet. The image given below represents how an Excel spreadsheet looks like:<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1407178 size-full aligncenter\" src=\"https:\/\/cdn1.byjus.com\/wp-content\/uploads\/2020\/09\/MS-Excel.png\" srcset=\"https:\/\/cdn1.byjus.com\/wp-content\/uploads\/2020\/09\/MS-Excel.png 1361w, https:\/\/cdn1.byjus.com\/wp-content\/uploads\/2020\/09\/MS-Excel.png 250w, https:\/\/cdn1.byjus.com\/wp-content\/uploads\/2020\/09\/MS-Excel.png 768w, https:\/\/cdn1.byjus.com\/wp-content\/uploads\/2020\/09\/MS-Excel.png 700w, https:\/\/cdn1.byjus.com\/wp-content\/uploads\/2020\/09\/MS-Excel.png 120w\" alt=\"MS Excel Spreadsheet\" width=\"1361\" height=\"705\" \/><strong>MS Excel<\/strong><\/p>\n<p dir=\"ltr\">MS Excel is a commercial spreadsheet application that is produced and distributed by Microsoft for Microsoft Windows and Mac OS operating systems. It features the ability to perform basic calculations, use graphing tools, create pivot tables and create macros, among other useful features.<\/p>\n<p dir=\"ltr\">Spreadsheet applications such as MS Excel use a collection of cells arranged into rows and columns to organize and manipulate data. They can also display data as charts, histograms and line graphs.<\/p>\n<p dir=\"ltr\">MS Excel permits users to arrange data in order to view various factors from different perspectives. Microsoft Visual Basic is a programming language used for applications in Excel, allowing users to create a variety of complex numerical methods. Programmers are given an option to code directly using the Visual Basic Editor, including Windows for writing code, debugging and code module organization.<\/p>\n<p dir=\"ltr\" style=\"text-align: center\"><strong><a href=\"https:\/\/entri.app\/blog\/computer-keyboard\/\">Computer Keyboard \u2013 Parts, Functions, Quiz<\/a><\/strong><\/p>\n<h2 id=\"need_for_excel_shortcuts\"><span class=\"ez-toc-section\" id=\"Need_for_Excel_Shortcuts\"><\/span><strong>Need for Excel Shortcuts<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Excel supports a plethora of keyboard shortcuts that help you work efficiently and increase productivity. Instead of accessing the toolbar with a mouse, two or three keystrokes are used to perform significant functions. Isn\u2019t that easier and time-saving? Using Excel shortcuts drastically increases the speed, and thus reduces work-time.<\/p>\n<p>Now the question is, if you have to memorize these shortcuts, the answer is no. However, it would be an advantage if you can remember a few of them. With regular practice, you will be able to remember most of the common Excel shortcuts.<\/p>\n<p>Let\u2019s now look at the Excel shortcuts cheat sheet, which you should know when working on Microsoft Excel. In this article, we have categorized 50 Excel shortcuts based on their operations. First, we will look at the workbook shortcut keys.<\/p>\n<p style=\"text-align: center\"><strong><a href=\"https:\/\/entri.app\/course\/data-science-and-machine-learning-course\/\" target=\"_blank\" rel=\"noopener\">Ready to take your data science skills to the next level? Sign up for a free demo today!<\/a><\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Benefits_of_Using_keyboard_Shortcuts\"><\/span><strong>Benefits of Using keyboard Shortcuts<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><strong>1. You Get Efficient Outputs<\/strong><\/h3>\n<p>Using shortcuts, you can copy all the text from a document by simply pressing\u00a0<strong>Ctrl+A<\/strong>, then\u00a0<strong>Ctrl+C<\/strong>, to copy all the text at a glance.<\/p>\n<p>Shortcuts increase your productivity and enable you to accomplish more tasks if you start utilizing them instead of a mouse. Using keyboard shortcuts maximizes the outputs you can produce in less time.<\/p>\n<p>On the other hand, it takes a lot of time if you use a mouse to select and drag all the way down to select a certain bit of text in a document.<\/p>\n<h3><strong>2. Enables Multi-Tasking<\/strong><\/h3>\n<p>Multi-tasking is a necessity in this day and age. Being a multi-tasker helps you to complete your daily work quickly.<\/p>\n<p>Multi-tasking is the ability to check the boxes on our daily to-do list while dealing with numerous tools and tabs at once.<\/p>\n<p>The significant advantage of using shortcuts is that it enables you to perform multitasking. Using shortcuts in your daily usage enables you to navigate through multitasking activities easily. Using keyboard shortcuts might sometimes feel difficult. Once you get used to them, though, you\u2019ll eventually become a ninja at the keyboard.<\/p>\n<h3><strong>3. Beneficial Effects On Health<\/strong><\/h3>\n<p>Using keyboard shortcuts is also beneficial for your health. It reduces the risk of repetitive strain injury\u00a0(RSI)\u00a0by cutting down your mouse activities. If you perform repetitive tasks using a mouse, there are many possibilities that you can develop RSI.<\/p>\n<p>Resting your palm heel on the desk and raising your fingers to click can cause RSI. If you start to use keyboard shortcuts, you can minimize mouse activities and save hundreds of mouse clicks daily. It reduces the fatigue in your fingers and wrists.<\/p>\n<h3><strong>4. Makes Your Work Precise<\/strong><\/h3>\n<p>Keyboard shortcuts are highly beneficial when you want to complete your work in a precise manner.<\/p>\n<p>It is also advisable in many organizations to perform more tasks via keyboard, rather than a mouse, to get the precise output. Typing and editing work is more accurate to handle through keyboard shortcuts. Fast movements of fingers on the keyboard make you look more professional. Using shortcuts not only makes you precise but also leaves a good impression on other colleagues too.<\/p>\n<h3><strong>5. Fast Working<\/strong><\/h3>\n<p>The other main and most significant advantage of using keyboard shortcuts is that you can perform tasks ten times faster than working with the mouse.<\/p>\n<p>It is because you take time to place the cursor on the correct option. You don\u2019t have to look for specific options when using keyboard shortcuts .This saves you a lot of time.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Keyboard_Shortcuts_in_Excel_for_Data_Entry\"><\/span><strong>Keyboard Shortcuts in Excel for Data Entry<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<article>\n<h3 id=\"Workbook\"><strong>Workbook Related Shortcuts<\/strong><\/h3>\n<figure class=\"wp-block-table is-style-regular\">\n<table class=\"has-base-2-background-color has-background\">\n<thead>\n<tr>\n<th>What it Does?<\/th>\n<th class=\"has-text-align-center\" data-align=\"center\">Windows Shortcut<\/th>\n<th class=\"has-text-align-center\" data-align=\"center\">Mac Shortcut<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Create a new blank Workbook<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + N<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">\u2318 + N<\/td>\n<\/tr>\n<tr>\n<td>Displays the Open Dialog box to Open\/Find a file<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + O<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">\u2318 + O<\/td>\n<\/tr>\n<tr>\n<td>Saves the Workbook with its current file name, location, and file type<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + S<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">\u2318 + S<\/td>\n<\/tr>\n<tr>\n<td><strong>Opens the Save As dialog box<\/strong><\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">F12<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">\u2318 + \u21e7 + S<\/td>\n<\/tr>\n<tr>\n<td>Opens the Print Preview Window<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + F2<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">\u2318 + P<\/td>\n<\/tr>\n<tr>\n<td>Maximize or Restore Selected Workbook Window<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + F10<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\"><\/td>\n<\/tr>\n<tr>\n<td>Minimize Workbook<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + F9<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\"><\/td>\n<\/tr>\n<tr>\n<td>Switch to the Next Workbook<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Tab<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\"><\/td>\n<\/tr>\n<tr>\n<td>Switch to the Previous Workbook<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + Tab<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\"><\/td>\n<\/tr>\n<tr>\n<td>Close Current Workbook<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">ALT + F4<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<div id=\"AdThrive_Content_3_desktop\" class=\"adthrive-ad adthrive-content adthrive-content-3 adthrive-ad-cls\" data-google-query-id=\"CPP92PqKz_0CFRjdcwEd-VsDqw\">\n<div id=\"google_ads_iframe_\/18190176,22499871287\/AdThrive_Content_3\/5cab42e1b13d6c3ef8c7c9cc_0__container__\">\n<h3><strong>Excel Cell Editing Shortcut<\/strong><\/h3>\n<\/div>\n<\/div>\n<figure class=\"wp-block-table is-style-regular\">\n<table class=\"has-base-2-background-color has-background\">\n<thead>\n<tr>\n<th>What it Does?<\/th>\n<th class=\"has-text-align-center\" data-align=\"center\">Windows Shortcut<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Edit Active Cell<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">F2<\/td>\n<\/tr>\n<tr>\n<td>Start a New Line in the Same Cell<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">ALT + ENTER<\/td>\n<\/tr>\n<tr>\n<td>Select One Character on the Right of the Cursor<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">SHIFT \u2192<\/td>\n<\/tr>\n<tr>\n<td>Select One Character on the Left of the Cursor<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">SHIFT \u2190<\/td>\n<\/tr>\n<tr>\n<td>Jump one Word on the Right of the Cursor<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl \u2192<\/td>\n<\/tr>\n<tr>\n<td>Jump one Word on the Left of the Cursor<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl \u2190<\/td>\n<\/tr>\n<tr>\n<td>Select one Word on the Right of the Cursor<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl Shift \u2192<\/td>\n<\/tr>\n<tr>\n<td>Select one Word on the Left of the Cursor<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl Shift \u2190<\/td>\n<\/tr>\n<tr>\n<td>Delete One Character on the Left of the Cursor<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Backspace<\/td>\n<\/tr>\n<tr>\n<td>Delete One Character on the Right of the Cursor<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Delete<\/td>\n<\/tr>\n<tr>\n<td>Delete to the End of the line (from the cursor)<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Delete<\/td>\n<\/tr>\n<tr>\n<td>Cancel Entry<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Esc<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><strong>Navigation Shortcuts in Excel<\/strong><\/h3>\n<\/figure>\n<figure class=\"wp-block-table is-style-regular\">\n<table class=\"has-base-2-background-color has-background\">\n<thead>\n<tr>\n<th>What it Does?<\/th>\n<th class=\"has-text-align-center\" data-align=\"center\">Windows Shortcut<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Move One Cell Up<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">\u2191<\/td>\n<\/tr>\n<tr>\n<td>Move One Cell Down<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">\u2193<\/td>\n<\/tr>\n<tr>\n<td>Move One Cell to the Right<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">\u2192<\/td>\n<\/tr>\n<tr>\n<td>Move One Cell to the Left<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">\u2190<\/td>\n<\/tr>\n<tr>\n<td>Down One Screen<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">PageDown<\/td>\n<\/tr>\n<tr>\n<td>Up One Screen<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">PageUp<\/td>\n<\/tr>\n<tr>\n<td>Move One Screen to the Right<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + PageDown<\/td>\n<\/tr>\n<tr>\n<td>Move One Screen to the Left<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + PageUp<\/td>\n<\/tr>\n<tr>\n<td>Move to the Right Edge of the Data Region<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl \u2192<\/td>\n<\/tr>\n<tr>\n<td>Move to the Left Edge of Data Region<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl \u2190<\/td>\n<\/tr>\n<tr>\n<td>Move to the Bottom edge of the data region<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl \u2193<\/td>\n<\/tr>\n<tr>\n<td>Move to the Top Edge of Data Region<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl \u2191<\/td>\n<\/tr>\n<tr>\n<td>Move to the Bottom-right used Cell in the Worksheet<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + End<\/td>\n<\/tr>\n<tr>\n<td>Go to the First Cell in the Current Region<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Home<\/td>\n<\/tr>\n<tr>\n<td>Move to the Beginning of the Row<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Home<\/td>\n<\/tr>\n<tr>\n<td>Move to Next Worksheet<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + PageDown<\/td>\n<\/tr>\n<tr>\n<td>Move to the Previous Worksheet<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + PageUp<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<div id=\"AdThrive_Content_5_desktop\" class=\"adthrive-ad adthrive-content adthrive-content-5 adthrive-ad-cls\" data-google-query-id=\"CMPwtfuKz_0CFfDYcwEdZQEN0Q\">\n<h3><strong>General Excel Shortcuts<\/strong><\/h3>\n<\/div>\n<figure class=\"wp-block-table is-style-regular\">\n<table class=\"has-base-2-background-color has-background\">\n<thead>\n<tr>\n<th>What it Does?<\/th>\n<th class=\"has-text-align-center\" data-align=\"center\">Windows Shortcut<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Opens Help<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">F1<\/td>\n<\/tr>\n<tr>\n<td>Repeats the last command or action<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Y<\/td>\n<\/tr>\n<tr>\n<td>Repeats the Last Action<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">F4<\/td>\n<\/tr>\n<tr>\n<td>Undo<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Z<\/td>\n<\/tr>\n<tr>\n<td>Spell Check<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">F7<\/td>\n<\/tr>\n<tr>\n<td>Apply Data Filter<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + L<\/td>\n<\/tr>\n<tr>\n<td>Activate Filter (when the cell with filter is selected)<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + \u2193<\/td>\n<\/tr>\n<tr>\n<td>Display Go To Dialog Box<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">F5<\/td>\n<\/tr>\n<tr>\n<td>Display Go To Dialog Box<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + G<\/td>\n<\/tr>\n<tr>\n<td>Recalculate All Workbooks<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">F9<\/td>\n<\/tr>\n<tr>\n<td>Calculate Active Worksheet<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Shift + F9<\/td>\n<\/tr>\n<tr>\n<td>Display the Print Menu<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + P<\/td>\n<\/tr>\n<tr>\n<td>Turn On End Mode<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">End<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: center\"><strong><a href=\"https:\/\/entri.app\/course\/data-science-and-machine-learning-course\/\" target=\"_blank\" rel=\"noopener\">\u00a0 Looking for a Data science and Machine learning Career? Explore Here!!<\/a><\/strong><\/p>\n<\/figure>\n<div id=\"AdThrive_Content_6_desktop\" class=\"adthrive-ad adthrive-content adthrive-content-6 adthrive-ad-cls\" data-google-query-id=\"COKO-oyLz_0CFVzdcwEd4XoOrQ\">\n<div id=\"google_ads_iframe_\/18190176,22499871287\/AdThrive_Content_6\/5cab42e1b13d6c3ef8c7c9cc_0__container__\">\n<h3><strong>Cut, Copy, and Paste Shortcuts in Excel<\/strong><\/h3>\n<\/div>\n<\/div>\n<figure class=\"wp-block-table is-style-regular\">\n<table class=\"has-base-2-background-color has-background\">\n<thead>\n<tr>\n<th>What it Does?<\/th>\n<th class=\"has-text-align-center\" data-align=\"center\">Windows Shortcut<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Copy Selected Cells<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + C<\/td>\n<\/tr>\n<tr>\n<td>Cut Selected Cells<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + X<\/td>\n<\/tr>\n<tr>\n<td>Paste Content from the Clipboard<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + V<\/td>\n<\/tr>\n<tr>\n<td>Copy Formula from the Cell Above<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + \u2018<\/td>\n<\/tr>\n<tr>\n<td>Copy Value from the Cell Above<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + SHIFT + \u2018<\/td>\n<\/tr>\n<tr>\n<td>Display Paste Special Dialog Box<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Alt + V<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<div id=\"AdThrive_Content_7_desktop\" class=\"adthrive-ad adthrive-content adthrive-content-7 adthrive-ad-cls\" data-google-query-id=\"CLmz8oyLz_0CFS0htwAd5L4KqA\">\n<div id=\"google_ads_iframe_\/18190176,22499871287\/AdThrive_Content_7\/5cab42e1b13d6c3ef8c7c9cc_0__container__\">\n<h3><strong>Data Entry Shortcuts in Excel<\/strong><\/h3>\n<\/div>\n<\/div>\n<figure class=\"wp-block-table is-style-regular\">\n<table class=\"has-base-2-background-color has-background\">\n<thead>\n<tr>\n<th>What it Does?<\/th>\n<th class=\"has-text-align-center\" data-align=\"center\">Windows Shortcut<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Enter and Move Down<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Enter<\/td>\n<\/tr>\n<tr>\n<td>Enter and Remain on the Same Cell<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Control + Enter<\/td>\n<\/tr>\n<tr>\n<td>Enter and Move Up<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Shift + Enter<\/td>\n<\/tr>\n<tr>\n<td>Enter and Move right<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Tab<\/td>\n<\/tr>\n<tr>\n<td>Enter and Move Left<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Shift + Tab<\/td>\n<\/tr>\n<tr>\n<td>Enter Same Data in All Selected Cells<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Control + Enter<\/td>\n<\/tr>\n<tr>\n<td>Display AutoComplete list<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + \u2193<\/td>\n<\/tr>\n<tr>\n<td>Fill Down<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + D<\/td>\n<\/tr>\n<tr>\n<td>Fill Right<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + R<\/td>\n<\/tr>\n<tr>\n<td>Insert Current Date<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + ;<\/td>\n<\/tr>\n<tr>\n<td>Insert Current Time<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + ;<\/td>\n<\/tr>\n<tr>\n<td>Start a New Line in the Same Cell<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + Enter<\/td>\n<\/tr>\n<tr>\n<td>Cancel Cell Entry<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">ESC<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<div id=\"AdThrive_Content_8_desktop\" class=\"adthrive-ad adthrive-content adthrive-content-8 adthrive-ad-cls\" data-google-query-id=\"CK31w4yLz_0CFRaO2AUdz6QIZg\">\n<div id=\"google_ads_iframe_\/18190176,22499871287\/AdThrive_Content_8\/5cab42e1b13d6c3ef8c7c9cc_0__container__\">\n<h3><strong>Clear Shortcuts in Excel<\/strong><\/h3>\n<\/div>\n<\/div>\n<figure class=\"wp-block-table is-style-regular\">\n<table class=\"has-base-2-background-color has-background\">\n<thead>\n<tr>\n<th>What it Does?<\/th>\n<th class=\"has-text-align-center\" data-align=\"center\">Windows Shortcut<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Clear\u00a0Everything<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + H + E + A<\/td>\n<\/tr>\n<tr>\n<td>Clear Formats Only<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + H + E + F<\/td>\n<\/tr>\n<tr>\n<td>Clear Content Only<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + H + E + C<\/td>\n<\/tr>\n<tr>\n<td>Clear Hyperlinks Only<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + H + E + L<\/td>\n<\/tr>\n<tr>\n<td>Clear Comments Only<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + H + E + M<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<div id=\"AdThrive_Content_9_desktop\" class=\"adthrive-ad adthrive-content adthrive-content-9 adthrive-ad-cls\" data-google-query-id=\"CNGs_IuLz_0CFRQ5twAdHLgAXQ\">\n<div id=\"google_ads_iframe_\/18190176,22499871287\/AdThrive_Content_9\/5cab42e1b13d6c3ef8c7c9cc_0__container__\">\n<h3><strong>Selection Shortcuts in Excel<\/strong><\/h3>\n<\/div>\n<\/div>\n<figure class=\"wp-block-table is-style-regular\">\n<table class=\"has-base-2-background-color has-background\">\n<thead>\n<tr>\n<th>What it Does?<\/th>\n<th class=\"has-text-align-center\" data-align=\"center\">Windows Shortcut<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Select the Current Region \/\u00a0Select All<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + A<\/td>\n<\/tr>\n<tr>\n<td>Select Visible Cells\u00a0in the Current Region<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + ;<\/td>\n<\/tr>\n<tr>\n<td>Select the Current Region Around the Active Cell<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + *<\/td>\n<\/tr>\n<tr>\n<td>Select Entire Row<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Shift + Space<\/td>\n<\/tr>\n<tr>\n<td>Select Entire Column<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Space<\/td>\n<\/tr>\n<tr>\n<td>Select All Cells that Contain Comments<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + O<\/td>\n<\/tr>\n<tr>\n<td>Select Row Differences<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + \\<\/td>\n<\/tr>\n<tr>\n<td>Select Column Differences<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + |<\/td>\n<\/tr>\n<tr>\n<td>Select Direct Precedents<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + [<\/td>\n<\/tr>\n<tr>\n<td>Select all Precedents<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + {<\/td>\n<\/tr>\n<tr>\n<td>Select Direct Dependents<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + ]<\/td>\n<\/tr>\n<tr>\n<td>Select all Dependents<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + }<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<div id=\"AdThrive_Content_10_desktop\" class=\"adthrive-ad adthrive-content adthrive-content-10 adthrive-ad-cls\" data-google-query-id=\"CNHarIuLz_0CFdwktwAdHDgFcQ\">\n<div id=\"google_ads_iframe_\/18190176,22499871287\/AdThrive_Content\/5cab42e1b13d6c3ef8c7c9cc_0__container__\">\n<h3><strong>Extending the Selection Shortcuts<\/strong><\/h3>\n<\/div>\n<\/div>\n<figure class=\"wp-block-table is-style-regular\">\n<table class=\"has-base-2-background-color has-background\">\n<thead>\n<tr>\n<th>What it Does?<\/th>\n<th class=\"has-text-align-center\" data-align=\"center\">Windows Shortcut<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Extend Selection to the Right by One Cell<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Shift + \u2192<\/td>\n<\/tr>\n<tr>\n<td>Extend Selection to the Left by One Cell<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Shift + \u2190<\/td>\n<\/tr>\n<tr>\n<td>Extend Selection Upwards by One Cell<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Shift + \u2191<\/td>\n<\/tr>\n<tr>\n<td>Extend Selection Downwards by One Cell<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Shift + \u2193<\/td>\n<\/tr>\n<tr>\n<td>Extend the Selection to the Right till the Last Cell<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + \u2192<\/td>\n<\/tr>\n<tr>\n<td>Extend the Selection to the Left till the Last Cell<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + \u2190<\/td>\n<\/tr>\n<tr>\n<td>Extend the Selection Upwards to the Last Cell<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + \u2191<\/td>\n<\/tr>\n<tr>\n<td>Extend Selection Upwards by One Screen<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Shift + PageUp<\/td>\n<\/tr>\n<tr>\n<td>Extend Selection Downwards by One Screen<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Shift + PageDown<\/td>\n<\/tr>\n<tr>\n<td>Extend Selection to the Right by One Screen<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">ALT + Shift + PageUp<\/td>\n<\/tr>\n<tr>\n<td>Extend Selection to the Left by One Screen<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">ALT + Shift + PageDown<\/td>\n<\/tr>\n<tr>\n<td>Extend Selection to the Start of the Row<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Shift + Home<\/td>\n<\/tr>\n<tr>\n<td>Extend Selection to First Cell in the Worksheet<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + Home<\/td>\n<\/tr>\n<tr>\n<td>Extend Selection to the Last Cell in the Worksheet<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + End<\/td>\n<\/tr>\n<tr>\n<td>Toggle Extend Selection Mode<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">F8<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: center\"><strong><a href=\"https:\/\/entri.app\/blog\/what-is-future-scope-of-computer-science-roles-salary\/\">What is Future Scope of Computer Science? Roles, Salary<\/a><\/strong><\/p>\n<\/figure>\n<div id=\"AdThrive_Content_11_desktop\" class=\"adthrive-ad adthrive-content adthrive-content-11 adthrive-ad-cls\" data-google-query-id=\"CMiriIuLz_0CFU7lcwEdJjkLAw\">\n<div id=\"google_ads_iframe_\/18190176,22499871287\/AdThrive_Content\/5cab42e1b13d6c3ef8c7c9cc_1__container__\">\n<h3><strong>Alignment Shortcuts<\/strong><\/h3>\n<\/div>\n<\/div>\n<figure class=\"wp-block-table is-style-regular\">\n<table class=\"has-base-2-background-color has-background\">\n<thead>\n<tr>\n<th>What it Does?<\/th>\n<th class=\"has-text-align-center\" data-align=\"center\">Windows Shortcut<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Align Content to the Center of the Cell<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + H + A + C<\/td>\n<\/tr>\n<tr>\n<td>Align Content to the Left of the Cell<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + H + A + L<\/td>\n<\/tr>\n<tr>\n<td>Align Content to the Right of the Cell<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + H + A + R<\/td>\n<\/tr>\n<tr>\n<td>Align Content to the Middle of the Cell<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + H + A + M<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3><strong>Hide\/Unhide (Rows, Columns, Objects) Shortcuts<\/strong><\/h3>\n<figure class=\"wp-block-table is-style-regular\">\n<table class=\"has-base-2-background-color has-background\">\n<thead>\n<tr>\n<th>What it Does?<\/th>\n<th class=\"has-text-align-center\" data-align=\"center\">Windows Shortcut<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Hide Selected Rows<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + 9<\/td>\n<\/tr>\n<tr>\n<td>Hide Selected Columns<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + 0<\/td>\n<\/tr>\n<tr>\n<td>Unhide Hidden Rows in Selection<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + 9<\/td>\n<\/tr>\n<tr>\n<td>Unhide Hidden Columns in Selection<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + 0<\/td>\n<\/tr>\n<tr>\n<td>Show\/Hide Objects<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + 6<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<div id=\"AdThrive_Content_12_desktop\" class=\"adthrive-ad adthrive-content adthrive-content-12 adthrive-ad-cls\" data-google-query-id=\"CJOXu4qLz_0CFXjocwEdf3gJug\">\n<div id=\"google_ads_iframe_\/18190176,22499871287\/AdThrive_Content\/5cab42e1b13d6c3ef8c7c9cc_2__container__\">\n<h3><strong>Insert Shortcuts<\/strong><\/h3>\n<\/div>\n<\/div>\n<figure class=\"wp-block-table is-style-regular\">\n<table class=\"has-base-2-background-color has-background\">\n<thead>\n<tr>\n<th>What it Does?<\/th>\n<th class=\"has-text-align-center\" data-align=\"center\">Windows Shortcut<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Insert New Line in the Same Cell<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + Enter<\/td>\n<\/tr>\n<tr>\n<td>Insert New Worksheet<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Shift + F11<\/td>\n<\/tr>\n<tr>\n<td>Insert Row\/Cell (shows a dialog box)<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + =<\/td>\n<\/tr>\n<tr>\n<td>Insert Current Date<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + ;<\/td>\n<\/tr>\n<tr>\n<td>Insert Current Time<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + ;<\/td>\n<\/tr>\n<tr>\n<td>Insert Table<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + T<\/td>\n<\/tr>\n<tr>\n<td>Insert Hyperlink<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + K<\/td>\n<\/tr>\n<tr>\n<td>Insert Argument Names into Formula<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + A<\/td>\n<\/tr>\n<tr>\n<td>Insert\/Edit Cell Comment<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Shift + F2<\/td>\n<\/tr>\n<tr>\n<td>Delete Row\/Cell (shows the dialog box)<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl \u2013<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<div id=\"AdThrive_Content_13_desktop\" class=\"adthrive-ad adthrive-content adthrive-content-13 adthrive-ad-cls\" data-google-query-id=\"CO-4v_2Kz_0CFaUHtwAdsdMCkA\">\n<div id=\"google_ads_iframe_\/18190176,22499871287\/AdThrive_Content\/5cab42e1b13d6c3ef8c7c9cc_3__container__\">\n<h3><strong>Formatting Shortcuts in Excel<\/strong><\/h3>\n<\/div>\n<\/div>\n<figure class=\"wp-block-table is-style-regular\">\n<table class=\"has-base-2-background-color has-background\">\n<thead>\n<tr>\n<th>What it Does?<\/th>\n<th class=\"has-text-align-center\" data-align=\"center\">Windows Shortcut<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Make Text Bold<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + B<\/td>\n<\/tr>\n<tr>\n<td>Make Text Italics<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + I<\/td>\n<\/tr>\n<tr>\n<td>Place outline Border around the Selected Cells<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + 7<\/td>\n<\/tr>\n<tr>\n<td>Remove Outline Border<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + _<\/td>\n<\/tr>\n<tr>\n<td>Underline Text<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + U<\/td>\n<\/tr>\n<tr>\n<td>Apply Strikethrough Format<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + 5<\/td>\n<\/tr>\n<tr>\n<td>Apply Indent<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt H 6<\/td>\n<\/tr>\n<tr>\n<td>Remove Indent<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt H 5<\/td>\n<\/tr>\n<tr>\n<td>Increase Font Size by One Step<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt H F G<\/td>\n<\/tr>\n<tr>\n<td>Decrease Font Size by One Step<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt H F K<\/td>\n<\/tr>\n<tr>\n<td>Apply the Number format with Two Decimal Places, Thousands Separator, and a Minus Sign for Negative Values<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + !<\/td>\n<\/tr>\n<tr>\n<td>Apply the Date format with the Day, Month, and Year<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + #<\/td>\n<\/tr>\n<tr>\n<td>Apply the Currency Format with Two Decimal Places<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + $<\/td>\n<\/tr>\n<tr>\n<td>Apply the Percentage Format with No Decimal Places<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + %<\/td>\n<\/tr>\n<tr>\n<td>Apply the Time format with the Hour and Minute, and indicate AM or PM<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + @<\/td>\n<\/tr>\n<tr>\n<td>Apply the General Number Format<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + ~<\/td>\n<\/tr>\n<tr>\n<td>Apply the Exponential Format<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + ^<\/td>\n<\/tr>\n<tr>\n<td>Displays the Format Style Dialog Box<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + \u2018<\/td>\n<\/tr>\n<tr>\n<td>Displays the Format Cells Dialog Box<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + 1<\/td>\n<\/tr>\n<tr>\n<td>Displays the Font Dialog Box<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Shift + Ctrl + F<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: center\"><strong><a href=\"https:\/\/entri.app\/course\/data-science-and-machine-learning-course\/\" target=\"_blank\" rel=\"noopener\">\u00a0 Looking for a Data science and Machine learning Career? Explore Here!!<\/a><\/strong><\/p>\n<\/figure>\n<div id=\"AdThrive_Content_14_desktop\" class=\"adthrive-ad adthrive-content adthrive-content-14 adthrive-ad-cls\" data-google-query-id=\"CPWiiv2Kz_0CFYrmcwEdkAkKAw\">\n<div id=\"google_ads_iframe_\/18190176,22499871287\/AdThrive_Content\/5cab42e1b13d6c3ef8c7c9cc_4__container__\">\n<h3><strong>Excel Formula-Related Shortcuts<\/strong><\/h3>\n<\/div>\n<\/div>\n<figure class=\"wp-block-table is-style-regular\">\n<table class=\"has-base-2-background-color has-background\">\n<thead>\n<tr>\n<th>What it Does?<\/th>\n<th class=\"has-text-align-center\" data-align=\"center\">Windows Shortcut<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Insert Autosum Formula<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + =<\/td>\n<\/tr>\n<tr>\n<td>While Typing a Formula, Switches Cell Reference from Absolute to Relative<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">F4<\/td>\n<\/tr>\n<tr>\n<td>Expand\/Collapse Formula Bar<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + U<\/td>\n<\/tr>\n<tr>\n<td>Display the Insert Function Dialog Box<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Shift + F3<\/td>\n<\/tr>\n<tr>\n<td>Enter a Formula as an Array Formula<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + Enter<\/td>\n<\/tr>\n<tr>\n<td>Evaluate Part of the Formula<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">F9<\/td>\n<\/tr>\n<tr>\n<td>Select the Array Containing the Active Cell<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">CTRL + \/<\/td>\n<\/tr>\n<tr>\n<td>Select All Cells Directly or Indirectly Referenced by Formulas in the Selection<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">CTRL + [<\/td>\n<\/tr>\n<tr>\n<td>Select Cells that Contain Formulas that Directly or Indirectly Reference the Active Cell<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">CTRL + ]<\/td>\n<\/tr>\n<tr>\n<td>Toggle Value\/Formula display<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + `<\/td>\n<\/tr>\n<tr>\n<td>Rechecks dependent formulas and then calculates all cells in all the open workbooks<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Alt + Shift + F9<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<div id=\"AdThrive_Content_15_desktop\" class=\"adthrive-ad adthrive-content adthrive-content-15 adthrive-ad-cls\" data-google-query-id=\"CM7Lz_2Kz_0CFRXUcwEdmS8Hvw\">\n<div id=\"google_ads_iframe_\/18190176,22499871287\/AdThrive_Content\/5cab42e1b13d6c3ef8c7c9cc_5__container__\">\n<h3><strong>Find and Replace Shortcuts<\/strong><\/h3>\n<\/div>\n<\/div>\n<figure class=\"wp-block-table is-style-regular\">\n<table class=\"has-base-2-background-color has-background\">\n<thead>\n<tr>\n<th>What it Does?<\/th>\n<th class=\"has-text-align-center\" data-align=\"center\">Windows Shortcut<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Display Find and Replace Dialog Box (Find Selected)<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + F<\/td>\n<\/tr>\n<tr>\n<td>Display Find and Replace Dialog Box (Replace Selected)<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + H<\/td>\n<\/tr>\n<tr>\n<td>Find Next Match<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Shift + F4<\/td>\n<\/tr>\n<tr>\n<td>Find the Previous Match<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + F4<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3><strong>Conditional Formatting Shortcuts<\/strong><\/h3>\n<figure class=\"wp-block-table is-style-regular\">\n<table class=\"has-base-2-background-color has-background\">\n<thead>\n<tr>\n<th>What it Does?<\/th>\n<th class=\"has-text-align-center\" data-align=\"center\">Windows Shortcut<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Open Conditional Formatting Dialog Box<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt O D<\/td>\n<\/tr>\n<tr>\n<td>Clear Conditional from Selected Cells<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt H L C S<\/td>\n<\/tr>\n<tr>\n<td>Clear Conditional from the Entire Worksheet<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt H L C E<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3><span id=\"Charting-Shortcuts\" class=\"ez-toc-section\"><\/span><strong>Charting Shortcuts<\/strong><\/h3>\n<figure class=\"wp-block-table is-style-regular\">\n<table class=\"has-base-2-background-color has-background\">\n<thead>\n<tr>\n<th>What it Does?<\/th>\n<th class=\"has-text-align-center\" data-align=\"center\">Windows Shortcut<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Inserts Chart in the Worksheet (using the selected data)<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + F1<\/td>\n<\/tr>\n<tr>\n<td>Inserts a ChartSheet with a Chart (using the selected data)<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">F11<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3><span id=\"Named-Ranges-Shortcuts\" class=\"ez-toc-section\"><\/span><strong>Named Ranges Shortcuts<\/strong><\/h3>\n<figure class=\"wp-block-table is-style-regular\">\n<table class=\"has-base-2-background-color has-background\">\n<thead>\n<tr>\n<th>What it Does?<\/th>\n<th class=\"has-text-align-center\" data-align=\"center\">Windows Shortcut<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Get a List of All Defined Named Ranges<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">F3<\/td>\n<\/tr>\n<tr>\n<td>Create Named Range from Selection<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + Shift + F3<\/td>\n<\/tr>\n<tr>\n<td>Define Name Dialog Box<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + F3<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3><strong>Pivot Table Shortcuts<\/strong><\/h3>\n<figure class=\"wp-block-table is-style-regular\">\n<table class=\"has-base-2-background-color has-background\">\n<thead>\n<tr>\n<th>What it Does?<\/th>\n<th class=\"has-text-align-center\" data-align=\"center\">Windows Shortcut<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Display Insert Pivot Table Dialog Box<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + N + V<\/td>\n<\/tr>\n<tr>\n<td>Open Pivot Table Wizard<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + D + P<\/td>\n<\/tr>\n<tr>\n<td>Select Entire Pivot Table (excluding Report Filters)<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + A<\/td>\n<\/tr>\n<tr>\n<td>Add\/Remove Checkmark for Selected Field in PivotTable Field List<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Space<\/td>\n<\/tr>\n<tr>\n<td>Group Selected Pivot Table Items<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + Shift + \u2192<\/td>\n<\/tr>\n<tr>\n<td>UnGroup Pivot Table Items<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + Shift + \u2190<\/td>\n<\/tr>\n<tr>\n<td>Select the Next Item in PivotTable Field List or Items List<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">\u2193<\/td>\n<\/tr>\n<tr>\n<td>Select a Previous Item in PivotTable Field List or Items List<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">\u2191<\/td>\n<\/tr>\n<tr>\n<td>Select Last Visible Item in List<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">End<\/td>\n<\/tr>\n<tr>\n<td>Select First Visible Item in List<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Home<\/td>\n<\/tr>\n<tr>\n<td>Open Field List for Active Cell<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Alt + \u2193<\/td>\n<\/tr>\n<tr>\n<td>Hide Selected Item or Field<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Ctrl + \u2013<\/td>\n<\/tr>\n<tr>\n<td>Opens Calculated Field dialog box (when the data field is selected)<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Shift + Ctrl + =<\/td>\n<\/tr>\n<tr>\n<td>Opens Calculated Item Dialog box (when field heading cell is Selected)<\/td>\n<td class=\"has-text-align-center\" data-align=\"center\">Shift + Ctrl + =<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: center\"><strong><a href=\"https:\/\/entri.app\/course\/data-science-and-machine-learning-course\/\" target=\"_blank\" rel=\"noopener\">\u00a0 Looking for a Data science and Machine learning Career? Explore Here!!<\/a><\/strong><\/p>\n<\/figure>\n<\/article>\n<article>\n<div class=\"engagingBanner\">\n<div class=\"detail-info-banner\" data-reactroot=\"\">\n<div class=\"left-clm\">\n<h2 id=\"conclusion\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><strong>Conclusion<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Excel shortcut keys will indeed help you build your reports and analysis faster and better. After reading this article, you would have understood the different types of Excel shortcuts related to the workbook, cell formatting, row and column formatting, and pivot tables.<\/p>\n<p>We hope you find these hacks useful and can easily master these shortcut keys by working on excel regularly.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"FAQs\"><\/span><strong>FAQs<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>1.<\/strong><b>What is MS Excel?<\/b><\/p>\n<p>Ans: MS Excel is a spreadsheet program where one can record data in the form of tables.<\/p>\n<p><strong>2.What are the benefits of Keyboard shortcuts for data entry?<\/strong><\/p>\n<p>Ans : Keyboard shortcuts help you out in decreasing the burden, decreasing the time, and easier\u00a0 \u00a0 \u00a0 \u00a0to use.<\/p>\n<p><strong>3. Shortcut key for close the\u00a0 Excel<\/strong><\/p>\n<p>Ans: Ctrl+F4<\/p>\n<p>4.<strong>Shortcut key for Move One Screen to the Right<\/strong><\/p>\n<p>Ans: Alt + PageDown<\/p>\n<table class=\"table\" width=\"1019\">\n<tbody>\n<tr>\n<td colspan=\"2\" rowspan=\"1\" data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Kerala PSC VFA Exam Information Links&quot;}\"><strong>Related Articles<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"284\"><strong><a href=\"https:\/\/entri.app\/blog\/computer-keyboard\/\">Computer Keyboard \u2013 Parts, Functions, Quiz<\/a><\/strong><\/td>\n<td width=\"284\"><strong><a href=\"https:\/\/entri.app\/blog\/what-is-future-scope-of-computer-science-roles-salary\/\">What is Future Scope of Computer Science? Roles, Salary<\/a><\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"284\"><strong><a href=\"https:\/\/entri.app\/blog\/difference-between-computer-science-and-data-science\/\">Difference Between Computer Science and Data Science<\/a><\/strong><\/td>\n<td width=\"284\"><a href=\"https:\/\/entri.app\/blog\/data-analysis-process-methods-types\/\" target=\"_blank\" rel=\"noopener\"><strong>Data Analysis \u2013 Process, Methods, Types<\/strong><\/a><\/td>\n<\/tr>\n<tr>\n<td width=\"284\"><b><a href=\"https:\/\/entri.app\/blog\/best-data-science-skills-for-data-science-career\/\" target=\"_blank\" rel=\"noopener\">Best Data Science Skills for Data Science Career<\/a><\/b><\/td>\n<td width=\"284\"><strong><a class=\"in-cell-link\" href=\"https:\/\/entri.app\/blog\/what-is-data-interpretation-methods-and-benefits\/\" target=\"_blank\" rel=\"noopener\">What is Data Interpretation? Methods and Benefits<\/a><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/article>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel\u00a0is extensively used across the globe to store and\u00a0analyze data. Despite various new data analytics tools in the market, Excel remains the go-to product for working with data. It has numerous in-built features, which makes it easier for you to organize your data. The shortcut keys in\u00a0Excel help you work on your data\u00a0in a [&hellip;]<\/p>\n","protected":false},"author":92,"featured_media":25555979,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[802,1864,1841],"tags":[],"class_list":["post-25555973","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-articles","category-data-science-ml","category-entri-skilling"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Keyboard Shortcuts in Excel for Data Entry - Entri Blog<\/title>\n<meta name=\"description\" content=\"In this article, we\u2019ll be discussing the various Excel shortcuts. These keyboard shortcuts are used to perform tasks faster and effectively.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Keyboard Shortcuts in Excel for Data Entry - Entri Blog\" \/>\n<meta property=\"og:description\" content=\"In this article, we\u2019ll be discussing the various Excel shortcuts. These keyboard shortcuts are used to perform tasks faster and effectively.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Entri Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/entri.me\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-11T14:30:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/Keyboard-Shortcuts-in-Excel-for-Data-Entry.png\" \/>\n\t<meta property=\"og:image:width\" content=\"820\" \/>\n\t<meta property=\"og:image:height\" content=\"615\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Aleena V Noushad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@entri_app\" \/>\n<meta name=\"twitter:site\" content=\"@entri_app\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Aleena V Noushad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/\"},\"author\":{\"name\":\"Aleena V Noushad\",\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/person\/282abb73bf1e2468d08cf486d1f075e2\"},\"headline\":\"Keyboard Shortcuts in Excel for Data Entry\",\"datePublished\":\"2023-03-11T14:30:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/\"},\"wordCount\":2646,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/entri.app\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/Keyboard-Shortcuts-in-Excel-for-Data-Entry.png\",\"articleSection\":[\"Articles\",\"Data Science and Machine Learning\",\"Entri Skilling\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/\",\"url\":\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/\",\"name\":\"Keyboard Shortcuts in Excel for Data Entry - Entri Blog\",\"isPartOf\":{\"@id\":\"https:\/\/entri.app\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/Keyboard-Shortcuts-in-Excel-for-Data-Entry.png\",\"datePublished\":\"2023-03-11T14:30:15+00:00\",\"description\":\"In this article, we\u2019ll be discussing the various Excel shortcuts. These keyboard shortcuts are used to perform tasks faster and effectively.\",\"breadcrumb\":{\"@id\":\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#primaryimage\",\"url\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/Keyboard-Shortcuts-in-Excel-for-Data-Entry.png\",\"contentUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/Keyboard-Shortcuts-in-Excel-for-Data-Entry.png\",\"width\":820,\"height\":615},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/entri.app\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Entri Skilling\",\"item\":\"https:\/\/entri.app\/blog\/category\/entri-skilling\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Data Science and Machine Learning\",\"item\":\"https:\/\/entri.app\/blog\/category\/entri-skilling\/data-science-ml\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Keyboard Shortcuts in Excel for Data Entry\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/entri.app\/blog\/#website\",\"url\":\"https:\/\/entri.app\/blog\/\",\"name\":\"Entri Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/entri.app\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/entri.app\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/entri.app\/blog\/#organization\",\"name\":\"Entri App\",\"url\":\"https:\/\/entri.app\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png\",\"contentUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png\",\"width\":989,\"height\":446,\"caption\":\"Entri App\"},\"image\":{\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/entri.me\/\",\"https:\/\/x.com\/entri_app\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/person\/282abb73bf1e2468d08cf486d1f075e2\",\"name\":\"Aleena V Noushad\",\"description\":\"Aleena is a passionate Blog writer and a Postgraduate in Master of Computer Application. She also holds a diploma in Aviation and Hospitality. She has been writing for Entri over the past three years, specialising in exam preparation and skill and career development\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/aleena-v-noushad-a81632126\/\"],\"url\":\"https:\/\/entri.app\/blog\/author\/aleena\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Keyboard Shortcuts in Excel for Data Entry - Entri Blog","description":"In this article, we\u2019ll be discussing the various Excel shortcuts. These keyboard shortcuts are used to perform tasks faster and effectively.","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:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"Keyboard Shortcuts in Excel for Data Entry - Entri Blog","og_description":"In this article, we\u2019ll be discussing the various Excel shortcuts. These keyboard shortcuts are used to perform tasks faster and effectively.","og_url":"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/","og_site_name":"Entri Blog","article_publisher":"https:\/\/www.facebook.com\/entri.me\/","article_published_time":"2023-03-11T14:30:15+00:00","og_image":[{"width":820,"height":615,"url":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/Keyboard-Shortcuts-in-Excel-for-Data-Entry.png","type":"image\/png"}],"author":"Aleena V Noushad","twitter_card":"summary_large_image","twitter_creator":"@entri_app","twitter_site":"@entri_app","twitter_misc":{"Written by":"Aleena V Noushad","Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#article","isPartOf":{"@id":"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/"},"author":{"name":"Aleena V Noushad","@id":"https:\/\/entri.app\/blog\/#\/schema\/person\/282abb73bf1e2468d08cf486d1f075e2"},"headline":"Keyboard Shortcuts in Excel for Data Entry","datePublished":"2023-03-11T14:30:15+00:00","mainEntityOfPage":{"@id":"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/"},"wordCount":2646,"commentCount":0,"publisher":{"@id":"https:\/\/entri.app\/blog\/#organization"},"image":{"@id":"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/Keyboard-Shortcuts-in-Excel-for-Data-Entry.png","articleSection":["Articles","Data Science and Machine Learning","Entri Skilling"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/","url":"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/","name":"Keyboard Shortcuts in Excel for Data Entry - Entri Blog","isPartOf":{"@id":"https:\/\/entri.app\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/Keyboard-Shortcuts-in-Excel-for-Data-Entry.png","datePublished":"2023-03-11T14:30:15+00:00","description":"In this article, we\u2019ll be discussing the various Excel shortcuts. These keyboard shortcuts are used to perform tasks faster and effectively.","breadcrumb":{"@id":"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#primaryimage","url":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/Keyboard-Shortcuts-in-Excel-for-Data-Entry.png","contentUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/Keyboard-Shortcuts-in-Excel-for-Data-Entry.png","width":820,"height":615},{"@type":"BreadcrumbList","@id":"https:\/\/entri.app\/blog\/keyboard-shortcuts-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/entri.app\/blog\/"},{"@type":"ListItem","position":2,"name":"Entri Skilling","item":"https:\/\/entri.app\/blog\/category\/entri-skilling\/"},{"@type":"ListItem","position":3,"name":"Data Science and Machine Learning","item":"https:\/\/entri.app\/blog\/category\/entri-skilling\/data-science-ml\/"},{"@type":"ListItem","position":4,"name":"Keyboard Shortcuts in Excel for Data Entry"}]},{"@type":"WebSite","@id":"https:\/\/entri.app\/blog\/#website","url":"https:\/\/entri.app\/blog\/","name":"Entri Blog","description":"","publisher":{"@id":"https:\/\/entri.app\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/entri.app\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/entri.app\/blog\/#organization","name":"Entri App","url":"https:\/\/entri.app\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png","contentUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png","width":989,"height":446,"caption":"Entri App"},"image":{"@id":"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/entri.me\/","https:\/\/x.com\/entri_app"]},{"@type":"Person","@id":"https:\/\/entri.app\/blog\/#\/schema\/person\/282abb73bf1e2468d08cf486d1f075e2","name":"Aleena V Noushad","description":"Aleena is a passionate Blog writer and a Postgraduate in Master of Computer Application. She also holds a diploma in Aviation and Hospitality. She has been writing for Entri over the past three years, specialising in exam preparation and skill and career development","sameAs":["https:\/\/www.linkedin.com\/in\/aleena-v-noushad-a81632126\/"],"url":"https:\/\/entri.app\/blog\/author\/aleena\/"}]}},"_links":{"self":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts\/25555973","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/users\/92"}],"replies":[{"embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/comments?post=25555973"}],"version-history":[{"count":7,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts\/25555973\/revisions"}],"predecessor-version":[{"id":25556052,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts\/25555973\/revisions\/25556052"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/media\/25555979"}],"wp:attachment":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/media?parent=25555973"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/categories?post=25555973"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/tags?post=25555973"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}