{"id":5074,"date":"2017-01-25T13:39:14","date_gmt":"2017-01-25T12:39:14","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=5074"},"modified":"2024-02-06T16:18:02","modified_gmt":"2024-02-06T15:18:02","slug":"top-3-excel-keyboard-tips","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-3-excel-keyboard-tips\/","title":{"rendered":"Top 3 Excel Keyboard Tips"},"content":{"rendered":"<p>There are a\u00a0lot of hidden keyboard tricks to increase your\u00a0efficiency in Excel. I am surprised myself with these hidden gems!<\/p>\n<p>Here are <strong>Top 3 Excel Keyboard Tips<\/strong>\u00a0for\u00a0<strong>Excel Power Users\u00a0<\/strong>like you!<\/p>\n<p>You will have a fun time increasing your productivity with these tricks!<\/p>\n<p>&nbsp;<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/3rWUMknUFkE?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/01\/Keyboard-Tips.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/01\/Keyboard-Tips.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"> download excel workbook <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Keyboard-Tips.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<div style=\"text-align: center;\">\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-3-excel-keyboard-tips\/#POWER_TRICK_1\" title=\"POWER TRICK #1:\">POWER TRICK #1:<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-3-excel-keyboard-tips\/#Display_Formulas_With_a_Single_Keypress\" title=\"Display Formulas With a Single Keypress\">Display Formulas With a Single Keypress<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-3-excel-keyboard-tips\/#CTRL\" title=\"[CTRL + `]\">[CTRL + `]<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-3-excel-keyboard-tips\/#CTRL-2\" title=\"CTRL + `\">CTRL + `<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-3-excel-keyboard-tips\/#POWER_TRICK_2\" title=\"POWER TRICK #2:\">POWER TRICK #2:<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-3-excel-keyboard-tips\/#Changing_Enter_Key_Behavior_in_Excel\" title=\"Changing Enter Key Behavior in Excel\">Changing Enter Key Behavior in Excel<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-3-excel-keyboard-tips\/#ENTER\" title=\"[ENTER]\">[ENTER]<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-3-excel-keyboard-tips\/#POWER_TRICK_3\" title=\"POWER TRICK #3:\">POWER TRICK #3:<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-3-excel-keyboard-tips\/#Move_Over_Multiple_Worksheets_Using_Shortcut_Keys\" title=\"Move Over Multiple Worksheets Using Shortcut Keys\">Move Over Multiple Worksheets Using Shortcut Keys<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-3-excel-keyboard-tips\/#CTRL_PAGE_UP_PAGE_DOWN\" title=\"[CTRL + PAGE UP \/ PAGE DOWN]\">[CTRL + PAGE UP \/ PAGE DOWN]<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"POWER_TRICK_1\"><\/span><span style=\"color: #ff0000;\"><b>POWER TRICK #1<\/b>:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Display_Formulas_With_a_Single_Keypress\"><\/span><span style=\"color: #0000ff;\">Display Formulas With a Single Keypress<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"CTRL\"><\/span><strong><span style=\"color: #0000ff;\">[CTRL + `]<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<p>&nbsp;<\/p>\n<p>I used to have\u00a0workbooks full of<strong>\u00a0formulas\u00a0<\/strong>and the only way for me to check each <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formula\" data-wpil-keyword-link=\"linked\">formula<\/a> was by clicking on\u00a0each cell, one cell at a time&#8230;pfff!<\/p>\n<p>Thankfully, here&#8217;s a quick tip that will speed up this process\u00a0<strong>by using a keyboard <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/\" target=\"_blank\" rel=\"noopener\" title=\"shortcut\" data-wpil-keyword-link=\"linked\">shortcut<\/a> to display all of the formulas<\/strong>!<\/p>\n<p>Let us use an existing workbook with formula results to demonstrate this. \u00a0Our workbook has a column that uses the\u00a0<strong>Replace\u00a0<\/strong>formula.<\/p>\n<p>Now, what if we want to check the correctness of each formula?<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Display-Formulas-00.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"\" class=\"alignnone size-full wp-image-4834\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Display-Formulas-00.png\" alt=\"display-formulas-00\" width=\"389\" height=\"206\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Display-Formulas-00.png 389w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Display-Formulas-00-300x159.png 300w\" sizes=\"(max-width: 389px) 100vw, 389px\"><\/a><\/p>\n<p>If we click on\u00a0a cell, then we can see the\u00a0<strong>Replace<\/strong> formula and its arguments. \u00a0This is the slow way&#8230;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Display-Formulas-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"\" class=\"alignnone size-full wp-image-4835\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Display-Formulas-01.png\" alt=\"display-formulas-01\" width=\"439\" height=\"253\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Display-Formulas-01.png 439w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Display-Formulas-01-300x173.png 300w\" sizes=\"(max-width: 439px) 100vw, 439px\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1<\/strong>:<\/span>\u00a0To display all of the formulas, press on your keyboard:<\/p>\n<h2><span class=\"ez-toc-section\" id=\"CTRL-2\"><\/span>CTRL + `<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The grave accent key <strong>`<\/strong> is usually located on the top left of the keyboard beside the number 1 key.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Display-Formulas-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"\" class=\"alignnone size-full wp-image-4836\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Display-Formulas-02.png\" alt=\"display-formulas-02\" width=\"758\" height=\"211\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Display-Formulas-02.png 758w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Display-Formulas-02-300x84.png 300w\" sizes=\"(max-width: 758px) 100vw, 758px\"><\/a><\/p>\n<p>You are now able to view all of the formulas, with just <strong>a single keypress!<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2<\/strong>:<\/span>\u00a0To display the results of the formulas instead, press on your keyboard\u00a0<strong>CTRL + ` <\/strong>again<strong>:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Display-Formulas-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"\" class=\"alignnone size-full wp-image-4837\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Display-Formulas-03.png\" alt=\"display-formulas-03\" width=\"390\" height=\"208\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Display-Formulas-03.png 390w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Display-Formulas-03-300x160.png 300w\" sizes=\"(max-width: 390px) 100vw, 390px\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"POWER_TRICK_2\"><\/span><span style=\"color: #ff0000;\"><b>POWER TRICK #2<\/b>:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Changing_Enter_Key_Behavior_in_Excel\"><\/span><span style=\"color: #0000ff;\">Changing Enter Key Behavior in Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"ENTER\"><\/span><strong><span style=\"color: #0000ff;\">[ENTER]<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<p>&nbsp;<\/p>\n<p><strong><a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-data-entry-form-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"Data Entry\" data-wpil-keyword-link=\"linked\">Data Entry<\/a><\/strong>\u00a0in Excel is a tedious process if Excel does not play its part. The great\u00a0thing with Excel is it is very customizable. One of the common scenarios is when I want Excel to move in a different direction when I press the <strong>ENTER\u00a0<\/strong>key.<\/p>\n<p>The normal behavior for the <strong>ENTER\u00a0<\/strong>key is to move downwards.<\/p>\n<p>However in our scenario, I&#8217;m trying to list down the <strong>exam scores for each student<\/strong>, so it would make sense every time I press the <strong>ENTER\u00a0<\/strong>key, we would move from <strong>left to right<\/strong>:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"\" class=\"alignnone size-full wp-image-4429\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Changing-Enter-Key-Behaviour-01.png\" alt=\"changing-enter-key-behaviour-01\" width=\"482\" height=\"112\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Changing-Enter-Key-Behaviour-01.png 482w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Changing-Enter-Key-Behaviour-01-300x70.png 300w\" sizes=\"(max-width: 482px) 100vw, 482px\"><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1<\/strong>:<\/span>\u00a0Go to\u00a0<strong>File.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Changing-Enter-Key-Behaviour-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"\" class=\"alignnone size-full wp-image-4430\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Changing-Enter-Key-Behaviour-02.png\" alt=\"changing-enter-key-behaviour-02\" width=\"637\" height=\"164\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Changing-Enter-Key-Behaviour-02.png 637w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Changing-Enter-Key-Behaviour-02-300x77.png 300w\" sizes=\"(max-width: 637px) 100vw, 637px\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2<\/strong>:<\/span>\u00a0Go to<strong> Options.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Changing-Enter-Key-Behaviour-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"\" class=\"alignnone size-full wp-image-4431\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Changing-Enter-Key-Behaviour-03.png\" alt=\"changing-enter-key-behaviour-03\" width=\"212\" height=\"671\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Changing-Enter-Key-Behaviour-03.png 212w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Changing-Enter-Key-Behaviour-03-95x300.png 95w\" sizes=\"(max-width: 212px) 100vw, 212px\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3: <\/strong><\/span>Go to <strong>Advanced &gt;\u00a0<\/strong><strong>After pressing Enter, move selection &gt; Direction: Right<\/strong>.<\/p>\n<p>This will change our <strong>ENTER\u00a0<\/strong>direction from Up to Down, into\u00a0<strong>Left to Right<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Changing-Enter-Key-Behaviour-04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"\" class=\"alignnone size-full wp-image-4432\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Changing-Enter-Key-Behaviour-04.png\" alt=\"changing-enter-key-behaviour-04\" width=\"606\" height=\"332\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Changing-Enter-Key-Behaviour-04.png 606w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Changing-Enter-Key-Behaviour-04-300x164.png 300w\" sizes=\"(max-width: 606px) 100vw, 606px\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4: <\/strong><\/span>Try it out! Enter a couple of scores and press <strong>ENTER<\/strong>. It will now move to the\u00a0<strong>right,\u00a0<\/strong>now data entry just got a lot more fun!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"\" class=\"alignnone size-full wp-image-4433\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Changing-Enter-Key-Behaviour-05.png\" alt=\"changing-enter-key-behaviour-05\" width=\"481\" height=\"120\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Changing-Enter-Key-Behaviour-05.png 481w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Changing-Enter-Key-Behaviour-05-300x75.png 300w\" sizes=\"(max-width: 481px) 100vw, 481px\"><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"POWER_TRICK_3\"><\/span><span style=\"color: #ff0000;\"><b>POWER TRICK #3<\/b>:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Move_Over_Multiple_Worksheets_Using_Shortcut_Keys\"><\/span><span style=\"color: #0000ff;\">Move Over Multiple Worksheets Using Shortcut Keys<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"CTRL_PAGE_UP_PAGE_DOWN\"><\/span><strong><span style=\"color: #0000ff;\">[CTRL + PAGE UP \/ PAGE DOWN]<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<p>&nbsp;<\/p>\n<p>There are a lot of times when I had workbooks with\u00a0<strong>a lot of worksheets\u00a0<\/strong>inside. Whenever I had to check each sheet one by one, it was a tedious process as I had no choice but to click the sheets one by one!<\/p>\n<p>Thankfully, here&#8217;s a quick tip that will speed up <strong>by using a keyboard shortcut to move over multiple worksheets<\/strong>!<\/p>\n<p>Let us use an existing workbook with multiple worksheets to demonstrate this.<\/p>\n<p>Our workbook has multiple sheets inside:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Move-Over-Multiple-Worksheets-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"\" class=\"alignnone size-full wp-image-4773\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Move-Over-Multiple-Worksheets-01.png\" alt=\"move-over-multiple-worksheets-01\" width=\"1368\" height=\"62\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Move-Over-Multiple-Worksheets-01.png 1368w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Move-Over-Multiple-Worksheets-01-300x14.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Move-Over-Multiple-Worksheets-01-1024x46.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Move-Over-Multiple-Worksheets-01-768x35.png 768w\" sizes=\"(max-width: 1368px) 100vw, 1368px\"><\/a><\/p>\n<p>The steps are very straightforward, which are outlined below:<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1<\/strong>:<\/span>\u00a0To move to the right, press on your keyboard\u00a0<strong>CTRL + PAGE DOWN:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Move-Over-Multiple-Worksheets-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"\" class=\"alignnone size-full wp-image-4774\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Move-Over-Multiple-Worksheets-02.png\" alt=\"move-over-multiple-worksheets-02\" width=\"1330\" height=\"125\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Move-Over-Multiple-Worksheets-02.png 1330w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Move-Over-Multiple-Worksheets-02-300x28.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Move-Over-Multiple-Worksheets-02-1024x96.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Move-Over-Multiple-Worksheets-02-768x72.png 768w\" sizes=\"(max-width: 1330px) 100vw, 1330px\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2<\/strong>:<\/span>\u00a0To move to the left, press on your keyboard\u00a0<strong>CTRL + PAGE\u00a0UP:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Move-Over-Multiple-Worksheets-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"\" class=\"alignnone size-full wp-image-4775\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Move-Over-Multiple-Worksheets-03.png\" alt=\"move-over-multiple-worksheets-03\" width=\"1363\" height=\"122\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Move-Over-Multiple-Worksheets-03.png 1363w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Move-Over-Multiple-Worksheets-03-300x27.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Move-Over-Multiple-Worksheets-03-1024x92.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Move-Over-Multiple-Worksheets-03-768x69.png 768w\" sizes=\"(max-width: 1363px) 100vw, 1363px\"><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are a\u00a0lot of hidden keyboard tricks to increase your\u00a0efficiency in Excel. I am surprised myself with these hidden gems! Here are Top 3 Excel Keyboard Tips\u00a0for\u00a0Excel Power Users\u00a0like you! You will have a fun time increasing your productivity with these tricks! &nbsp; ? download excel workbook Keyboard-Tips.xlsx &nbsp; POWER TRICK #1: Display Formulas With [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":15862,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[7,10],"tags":[200,186,185,183],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/5074"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=5074"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/5074\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/15862"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=5074"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=5074"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=5074"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}