Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cells selection
When I use the curser to select a single cell, multiple cells are selected.
If I tab, the highlight stays within the selected cells. When I use the arrow keys a single cell selection accures and things work okay. This appears to be only in this worrkbook where the problem accurs on multiple sheets though not on all sheets. I am using MS Excel 2007 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cells selection
Hi,
In Excel 2003 I'd tap F8 to cure that but Microsoft have probably changed that because they can!! Mike "Davey" wrote: When I use the curser to select a single cell, multiple cells are selected. If I tab, the highlight stays within the selected cells. When I use the arrow keys a single cell selection accures and things work okay. This appears to be only in this worrkbook where the problem accurs on multiple sheets though not on all sheets. I am using MS Excel 2007 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cells selection
Try setting the Zoom level a little lower.
The multiple cell selection is a bug in Excel 2007. The zoom-changing appears to fix it. I don't have 2007 but a few postings have made the suggestion and it seems to work. Here is one such posting. http://tinyurl.com/3wofsf Post back please to confirm if this works or is bogus advice. Gord Dibben MS Excel MVP On Tue, 23 Dec 2008 06:21:01 -0800, Davey wrote: When I use the curser to select a single cell, multiple cells are selected. If I tab, the highlight stays within the selected cells. When I use the arrow keys a single cell selection accures and things work okay. This appears to be only in this worrkbook where the problem accurs on multiple sheets though not on all sheets. I am using MS Excel 2007 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cells selection
I tried F8 but that added more cells to the selection really confusing me.
And they won't give me Excel 2003 back. One step forward two steps back! Sort of like the state of the economy;-) "Mike H" wrote: Hi, In Excel 2003 I'd tap F8 to cure that but Microsoft have probably changed that because they can!! Mike "Davey" wrote: When I use the curser to select a single cell, multiple cells are selected. If I tab, the highlight stays within the selected cells. When I use the arrow keys a single cell selection accures and things work okay. This appears to be only in this worrkbook where the problem accurs on multiple sheets though not on all sheets. I am using MS Excel 2007 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cells selection
Thanks for the suggestion of changing the zoom. It worked for me. I have
also found that if you minimize the spreadsheet and work on it stretched out to full size but still minimized that works as well. Crazy annoying glitch! Thanks again! This was very helpful. "Gord Dibben" wrote: Try setting the Zoom level a little lower. The multiple cell selection is a bug in Excel 2007. The zoom-changing appears to fix it. I don't have 2007 but a few postings have made the suggestion and it seems to work. Here is one such posting. http://tinyurl.com/3wofsf Post back please to confirm if this works or is bogus advice. Gord Dibben MS Excel MVP On Tue, 23 Dec 2008 06:21:01 -0800, Davey wrote: When I use the curser to select a single cell, multiple cells are selected. If I tab, the highlight stays within the selected cells. When I use the arrow keys a single cell selection accures and things work okay. This appears to be only in this worrkbook where the problem accurs on multiple sheets though not on all sheets. I am using MS Excel 2007 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cells selection
Thanks for the feedback on the Zoom change working.
Gord On Fri, 20 Feb 2009 14:09:01 -0800, Allyx wrote: Thanks for the suggestion of changing the zoom. It worked for me. I have also found that if you minimize the spreadsheet and work on it stretched out to full size but still minimized that works as well. Crazy annoying glitch! Thanks again! This was very helpful. "Gord Dibben" wrote: Try setting the Zoom level a little lower. The multiple cell selection is a bug in Excel 2007. The zoom-changing appears to fix it. I don't have 2007 but a few postings have made the suggestion and it seems to work. Here is one such posting. http://tinyurl.com/3wofsf Post back please to confirm if this works or is bogus advice. Gord Dibben MS Excel MVP On Tue, 23 Dec 2008 06:21:01 -0800, Davey wrote: When I use the curser to select a single cell, multiple cells are selected. If I tab, the highlight stays within the selected cells. When I use the arrow keys a single cell selection accures and things work okay. This appears to be only in this worrkbook where the problem accurs on multiple sheets though not on all sheets. I am using MS Excel 2007 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cells selection
Same exact thing was happening to me. Multiple cells were being selected,
while I only clicked on one. I changed the zoom to 90% and then back to 100% and the bug was fixed! "Gord Dibben" wrote: Thanks for the feedback on the Zoom change working. Gord On Fri, 20 Feb 2009 14:09:01 -0800, Allyx wrote: Thanks for the suggestion of changing the zoom. It worked for me. I have also found that if you minimize the spreadsheet and work on it stretched out to full size but still minimized that works as well. Crazy annoying glitch! Thanks again! This was very helpful. "Gord Dibben" wrote: Try setting the Zoom level a little lower. The multiple cell selection is a bug in Excel 2007. The zoom-changing appears to fix it. I don't have 2007 but a few postings have made the suggestion and it seems to work. Here is one such posting. http://tinyurl.com/3wofsf Post back please to confirm if this works or is bogus advice. Gord Dibben MS Excel MVP On Tue, 23 Dec 2008 06:21:01 -0800, Davey wrote: When I use the curser to select a single cell, multiple cells are selected. If I tab, the highlight stays within the selected cells. When I use the arrow keys a single cell selection accures and things work okay. This appears to be only in this worrkbook where the problem accurs on multiple sheets though not on all sheets. I am using MS Excel 2007 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cells selection
Thanks for the confirmation.
Gord On Wed, 22 Apr 2009 09:54:15 -0700, andalusiana wrote: Same exact thing was happening to me. Multiple cells were being selected, while I only clicked on one. I changed the zoom to 90% and then back to 100% and the bug was fixed! "Gord Dibben" wrote: Thanks for the feedback on the Zoom change working. Gord On Fri, 20 Feb 2009 14:09:01 -0800, Allyx wrote: Thanks for the suggestion of changing the zoom. It worked for me. I have also found that if you minimize the spreadsheet and work on it stretched out to full size but still minimized that works as well. Crazy annoying glitch! Thanks again! This was very helpful. "Gord Dibben" wrote: Try setting the Zoom level a little lower. The multiple cell selection is a bug in Excel 2007. The zoom-changing appears to fix it. I don't have 2007 but a few postings have made the suggestion and it seems to work. Here is one such posting. http://tinyurl.com/3wofsf Post back please to confirm if this works or is bogus advice. Gord Dibben MS Excel MVP On Tue, 23 Dec 2008 06:21:01 -0800, Davey wrote: When I use the curser to select a single cell, multiple cells are selected. If I tab, the highlight stays within the selected cells. When I use the arrow keys a single cell selection accures and things work okay. This appears to be only in this worrkbook where the problem accurs on multiple sheets though not on all sheets. I am using MS Excel 2007 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cells Selection Darker | Excel Discussion (Misc queries) | |||
Selection of specific cells | Excel Discussion (Misc queries) | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
Image behind a selection of cells?? | Excel Discussion (Misc queries) | |||
Formatting Selection of cells. | Excel Discussion (Misc queries) |