{"id":109,"date":"2018-12-27T17:00:00","date_gmt":"2018-12-27T17:00:00","guid":{"rendered":"https:\/\/www.howtoexcel.info\/Excel\/?p=109"},"modified":"2021-09-29T06:04:05","modified_gmt":"2021-09-29T06:04:05","slug":"make-ctrl-down-to-work","status":"publish","type":"post","link":"https:\/\/www.howtoexcel.info\/Excel\/make-ctrl-down-to-work\/","title":{"rendered":"Ctrl + Down (or any arrow) not working properly in MS Excel. How to Solve?"},"content":{"rendered":"\r\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">Users often find that Ctrl Down key function stops at an intermediate cell and does not navigate up to the bottom of the sheet. This is because it stops at the first blank cell in the column.<\/span><\/p>\r\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">One solution to avoid this issue is to fill in the blank cells with value 0 (zero) if it doesn&#8217;t affect the purpose of the sheet.<\/span><\/p>\r\n<p><span style=\"color: #000000;\">Step 1 &#8211; Before entering values in blank cells<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.howtoexcel.info\/Images\/ctrl_down\/ctrl_down1.JPG\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">Step 2 &#8211; Select the range of cells that you need to navigate. Go to &#8216;Find &amp; Select&#8217; in the Home tab. Choose the option &#8216;Go To Special&#8217;. Select &#8216;Blanks&#8217; as below and click ok.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.howtoexcel.info\/Images\/ctrl_shift_down\/ctrl_shift_down3.JPG\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"color: #000000;\"> Step 3 &#8211; Type &#8216;0&#8217;. Press &#8216;Ctrl+Enter&#8217;. Excel fills in all blank cells with the value 0.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.howtoexcel.info\/Images\/ctrl_shift_down\/ctrl_shift_down5.JPG\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\"> Step 4 &#8211; Now press Ctrl+Down to navigate up to the bottom (up to the row which you selected in Step 2)<\/span><\/p>\r\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">Another problem with Ctrl+Down function is associated with Transition Navigation Keys. If the key combination is not at all working, try changing the settings by going to Excel Options&gt; Advanced&gt; Tools&gt;Options&gt;Uncheck Transition Navigation Keys.<\/span><\/p>\r\n<p><span style=\"color: #000000; font-size: 12px;\"><strong>Search engine keywords for this question:<\/strong><\/span><\/p>\r\n<p><span style=\"color: #000000; font-size: 10px;\">Ctrl Arrow problem<\/span><br \/><span style=\"color: #000000; font-size: 10px;\">Ctrl Down\/Up arrow not working<\/span><br \/><span style=\"color: #000000; font-size: 10px;\">Ctrl Left\/Right problem<\/span><br \/><span style=\"color: #000000; font-size: 10px;\">Ctrl Right Arrow improper<\/span><br \/><span style=\"color: #000000; font-size: 10px;\">Ctrl Down not work<\/span><br \/><span style=\"color: #000000; font-size: 10px;\">Ctrl+Down issue<\/span><br \/><span style=\"color: #000000; font-size: 10px;\">Ctrl + Down not working properly<\/span><br \/><span style=\"color: #000000; font-size: 10px;\">Ctrl plus Down selection problem<\/span><br \/><span style=\"color: #000000; font-size: 10px;\">Ctrl Arrow combination not return desired selection<\/span><br \/><span style=\"color: #000000; font-size: 10px;\">Ctrl+Down stops between<\/span><br \/><span style=\"color: #000000; font-size: 10px;\">Ctrl+Down navigation problem<\/span><\/p>\r\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/109"}],"collection":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/comments?post=109"}],"version-history":[{"count":7,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/109\/revisions"}],"predecessor-version":[{"id":269,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/109\/revisions\/269"}],"wp:attachment":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/media?parent=109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/categories?post=109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/tags?post=109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}