Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excel select a range instead of just the cell clicked on
In Excel 2007, when I click on a cell, it arbitrarily selects several
adjacent cells as well. If I touch a directional arrow on the keyboard to move (for example) up and then back down to the cell I want, it lets go, but this is a major nuisance. It's also happening to two other people I work with and we're all in different files. Why does this occur and how can I make it stop? Is it a bug in the software? Thanks for any help you can offer. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excel select a range instead of just the cell clicked on
Does it select the range from the cell that was selected to the new cell you
select? You might have hit the F8 key, which toggles the selection mode. If you see "EXT" in the status bar, over toward the right of the screen, this is what happened. Simply hit F8 again to toggle back to regular mode. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Geekette" wrote in message ... In Excel 2007, when I click on a cell, it arbitrarily selects several adjacent cells as well. If I touch a directional arrow on the keyboard to move (for example) up and then back down to the cell I want, it lets go, but this is a major nuisance. It's also happening to two other people I work with and we're all in different files. Why does this occur and how can I make it stop? Is it a bug in the software? Thanks for any help you can offer. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excel select a range instead of just the cell clicked on
Does the cell you are clicking on contain a formula? "Geekette" wrote: In Excel 2007, when I click on a cell, it arbitrarily selects several adjacent cells as well. If I touch a directional arrow on the keyboard to move (for example) up and then back down to the cell I want, it lets go, but this is a major nuisance. It's also happening to two other people I work with and we're all in different files. Why does this occur and how can I make it stop? Is it a bug in the software? Thanks for any help you can offer. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excel select a range instead of just the cell clicked
I'm running into the same problem on Excel 2007 where when I click on one
cell the selection expands to include the cell to the right. Status bar doesn't show Extending. Hitting F8 does show Extending and extends the selection even further. Hitting F8 again brings it back to just selecting two cells. This only happens on one spreadsheet. Other spreadsheets are fine. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excel select a range instead of just the cell clicked
Change the Zoom setting slightly to see if that stops the multi-cell
selection. Gord Dibben MS Excel MVP On Fri, 27 Feb 2009 08:47:03 -0800, Ross Comer wrote: I'm running into the same problem on Excel 2007 where when I click on one cell the selection expands to include the cell to the right. Status bar doesn't show Extending. Hitting F8 does show Extending and extends the selection even further. Hitting F8 again brings it back to just selecting two cells. This only happens on one spreadsheet. Other spreadsheets are fine. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excel select a range instead of just the cell clicked
That indicates something fishy with the one workbook.
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Ross Comer" wrote in message ... I'm running into the same problem on Excel 2007 where when I click on one cell the selection expands to include the cell to the right. Status bar doesn't show Extending. Hitting F8 does show Extending and extends the selection even further. Hitting F8 again brings it back to just selecting two cells. This only happens on one spreadsheet. Other spreadsheets are fine. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excel select a range instead of just the cell clicked
I've narrowed this down to only occuring when the worksheet in question is in
Page Layout View. Clicking some cells also selects the adjacent cell. Changing the view to Normal restores normal behavior. This only occurs on one machine. Another machine opening the same workbook works fine in all views. I have taken the workbook in question and deleted all data and the issue still happens. If there is nothing obvious don't spend too much time on this as I have a contact who might be able to help as well. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel msgbox when cell range is clicked | Excel Discussion (Misc queries) | |||
How can I pop up a picture when a cell is clicked on Excel? | Excel Discussion (Misc queries) | |||
How can I detect that an excel cell has been clicked | Excel Discussion (Misc queries) | |||
HOW DO I GET AN X IN A CELL IN EXCEL TO COME & GO WHEN CLICKED | Excel Discussion (Misc queries) | |||
Select cell from range based on input in excel xp | Excel Discussion (Misc queries) |