{"id":338,"date":"2021-09-03T19:59:39","date_gmt":"2021-09-03T19:59:39","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/office-excel-click-1-cell-selects-multiple-7549-html"},"modified":"2021-09-03T19:59:39","modified_gmt":"2021-09-03T19:59:39","slug":"office-excel-click-1-cell-selects-multiple-7549-html","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/excel-click-1-cell-selects-multiple\/7549.html","title":{"rendered":"Solved Excel click 1 cell selects multiple"},"content":{"rendered":"<p><td>I&#8217;m running across the same issue as a previous poster ( <a href=\"https:\/\/computing.net\/answers\/office\/excel-2007-auto-multiple-row-\/7291.html\" target=\"_blank\" rel=\"noopener\">https:\/\/computing.net\/answers\/of&#8230;<\/a> ) in Excel 2007.  Namely, that often when I click on a cell in excel, that cell and several cells below it will be selected (rather than just the cell I&#8217;m clicking on).  The previous post had no replies posted, so I don&#8217;t know what causes it or how to solve it.<\/p>\n<p>One thing that I have noticed is that if I click super-fast, I only select one cell.  If my clicks are longer (a longer fraction of a second), it will select cells in multiple rows.  What it looks like is happening from my experimentation, is that Excel is interpreting my click as a multi-column select, and for some reason is using a point x pixels down as the end of the drag.  Thus, multiple rows are selected.  If the row is taller and I click near the top of the cell, I only get one cell selected, whereas when I click near the bottom of the cell, multiple rows are selected.<\/p>\n<p>Re-opening the document I was working on seems to have returned Excel\u2019s behavior to normal.  I haven\u2019t used Excel long enough to know if this will be a recurring issue.  That being said, is this something others have run across (other than the previous poster I mentioned), and do people know what\u2019s causing it and if there\u2019s a fix available?<\/p>\n<p>Thanks.<\/p>\n<\/td>\n<td>I have the same problem. However, I found that if you right-click, (menu pops up), but only the one cell is selected. Then, if you immediately, left-click the menu goes away and the cell remains the only one selected. So I&#8217;ve just got into the habit of doing right-click\/left-click combos for cell selection whenever this problem happens. <\/p>\n<p><font size=\"2\" color=\"gray\">Regards,<\/p>\n<p>Gerry<\/p>\n<p><\/font><\/p>\n<\/td>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","meta":{"inline_featured_image":false,"iawp_total_views":6},"question-category":[],"question_tags":[],"class_list":["post-338","question","type-question","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/338","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=338"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=338"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=338"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}