Cell click on one cell selects 2 or 3 cells?
I just got 2007 (I want 200 back) and a lot of the time when click on an empty cell 2 or more below it are selected and the typing goes on the bottom row. I just want to select the cell I click on.
I am having trouble selecting a single cell on a worksheet. When I click in a cell, excel selects more than one cell at a time. Sometimes it will select three or more cells below the selection in addition to the cell I require (screen capture attached). In this image, I selected 4.728 and excel selected the two cells below. If I hold down the left-click I am able to scroll back to select the cell but it is very awkward. It does not matter how careful I am with the selection.
Is there a setting to prevent this happening. In AutoCAD, it is possible to reduce the size of the selection-cursor but I am unable to locate the adjustment. I have increased the size of the cells to 200% and the problem still occurs. The problem is intermittent but when it starts, it stays. Logging off and on again seems to solve the problem for a limited time.
Current I have some script which alters a cell OnSelectionChange. Is there anyway to catch the user clicking on the currently selected? Meaning, a cell is currently selected, but the use clicks on it again.
What I am trying to accomplish.
These cells are marked with an X. I am trying to simulate single click functionality. If you click on a cell and there is no X, it puts one. If you click on a cell and there is a X, it removes it. What I have works great except when you click on a cell and it adds the X, you have to change the selected cell to get the script to remove the X. By doing that you added another X to a different cell.
When I load MS-Excel whether through an excel file or directly from ms excel icon, I get the same problem. as soon as I click on any cell, it acts like am holding the mouse button and selecting all cells as I move with the mouse. right click doesn't also work. I can't close the file by clicking the Close button on the top corner. I cant access the menu bar even with the keyboard. I doubt if its the mouse. because the mouse works fine with all other programs etc etc.
Excel clicking selects multiple cells instead of a single cell
Related Applications & Scripts
The Double click script (as2.0) is, as the name is saying, the script for double click button.
After the user selects an option in the pulldown menu, the new page opens in a new window! This is useful when linking to sites not within your site when you do not want the user to leave your site. Your site will remain open in the other window so the visitor can come back to it when the are finished with the popup page. You can even control the size of the popup window, whether it has scrollbars, menubars, toolbars, etc.
This is a useful and easy to customize right click menu for Flash, coded in ActionScript 3.
This jQuery plugin replaces default checkboxes, selects and radioboxes with more flexible and robust counterparts.
Say goodbye to the pesky and inconsistent styling. Each element is created using common HTML elements like spans and lists. You only need to alter few CSS rules to completely change their appearance and perfectly match them to your website. Now thats full control.