Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
automatically selecting contiguous cells - Why?
Using 2007. What am I doing that will cause the automatic selection of 2-3
continuous cells? I will just be working away, then the next time I click on a cell, two or three cells will get selected. Then ever after in that session everytime I click , again, two or three cells will become selected. I am unconsciously doing something - but I don't know what. There are no formulas, no auto filling, nothing complicated going on. Thanks to someone who can clear up this mystery to me. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
automatically selecting contiguous cells - Why?
I'd guess you have merged cells there.
-- HTH, Barb Reinhardt "becder" wrote: Using 2007. What am I doing that will cause the automatic selection of 2-3 continuous cells? I will just be working away, then the next time I click on a cell, two or three cells will get selected. Then ever after in that session everytime I click , again, two or three cells will become selected. I am unconsciously doing something - but I don't know what. There are no formulas, no auto filling, nothing complicated going on. Thanks to someone who can clear up this mystery to me. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
automatically selecting contiguous cells - Why?
It's a bug in 2007
Have a look at this google search thread for some ideas. http://tinyurl.com/5h2uua Gord Dibben MS Excel MVP On Sun, 7 Sep 2008 05:06:00 -0700, becder wrote: Using 2007. What am I doing that will cause the automatic selection of 2-3 continuous cells? I will just be working away, then the next time I click on a cell, two or three cells will get selected. Then ever after in that session everytime I click , again, two or three cells will become selected. I am unconsciously doing something - but I don't know what. There are no formulas, no auto filling, nothing complicated going on. Thanks to someone who can clear up this mystery to me. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
automatically selecting contiguous cells - Why?
Great. Thanks for something to think about. I guess I am in Page Layout view
a lot. I will try and be more observant about what is happening as I have this little 'bug' appear. Sounds like it drives a ton of people nuts, me included. Thanks Gord. -becky "Gord Dibben" wrote: It's a bug in 2007 Have a look at this google search thread for some ideas. http://tinyurl.com/5h2uua Gord Dibben MS Excel MVP On Sun, 7 Sep 2008 05:06:00 -0700, becder wrote: Using 2007. What am I doing that will cause the automatic selection of 2-3 continuous cells? I will just be working away, then the next time I click on a cell, two or three cells will get selected. Then ever after in that session everytime I click , again, two or three cells will become selected. I am unconsciously doing something - but I don't know what. There are no formulas, no auto filling, nothing complicated going on. Thanks to someone who can clear up this mystery to me. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
automatically selecting contiguous cells - Why?
THE WORK AROUND -
In page layout view, minimize the white space between pages. This, for some reason, works. To do this: 1. To hide the white space, hover your cursor on the break between pages until you see the tool tip €śHide White Space€ť 2. Perform a single left click of the mouse and the gap should close. 3. To make the white space reappear, simply left click in the gap between the pages when the tool tip displays €śShow White Space€ť The issue is a known bug that Microsoft has yet to correct in nearly three years. FIX IT MICROSOFT! "becder" wrote: Great. Thanks for something to think about. I guess I am in Page Layout view a lot. I will try and be more observant about what is happening as I have this little 'bug' appear. Sounds like it drives a ton of people nuts, me included. Thanks Gord. -becky "Gord Dibben" wrote: It's a bug in 2007 Have a look at this google search thread for some ideas. http://tinyurl.com/5h2uua Gord Dibben MS Excel MVP On Sun, 7 Sep 2008 05:06:00 -0700, becder wrote: Using 2007. What am I doing that will cause the automatic selection of 2-3 continuous cells? I will just be working away, then the next time I click on a cell, two or three cells will get selected. Then ever after in that session everytime I click , again, two or three cells will become selected. I am unconsciously doing something - but I don't know what. There are no formulas, no auto filling, nothing complicated going on. Thanks to someone who can clear up this mystery to me. |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
automatically selecting contiguous cells - Why?
"Chris" wrote: THE WORK AROUND - In page layout view, minimize the white space between pages. This, for some reason, works. To do this: 1. To hide the white space, hover your cursor on the break between pages until you see the tool tip €śHide White Space€ť 2. Perform a single left click of the mouse and the gap should close. 3. To make the white space reappear, simply left click in the gap between the pages when the tool tip displays €śShow White Space€ť The issue is a known bug that Microsoft has yet to correct in nearly three years. FIX IT MICROSOFT! "becder" wrote: Great. Thanks for something to think about. I guess I am in Page Layout view a lot. I will try and be more observant about what is happening as I have this little 'bug' appear. Sounds like it drives a ton of people nuts, me included. Thanks Gord. -becky "Gord Dibben" wrote: It's a bug in 2007 Have a look at this google search thread for some ideas. http://tinyurl.com/5h2uua Gord Dibben MS Excel MVP On Sun, 7 Sep 2008 05:06:00 -0700, becder wrote: Using 2007. What am I doing that will cause the automatic selection of 2-3 continuous cells? I will just be working away, then the next time I click on a cell, two or three cells will get selected. Then ever after in that session everytime I click , again, two or three cells will become selected. I am unconsciously doing something - but I don't know what. There are no formulas, no auto filling, nothing complicated going on. Thanks to someone who can clear up this mystery to me. I have the same issue with some documents . If I open the brand new excel spreadsheet , it will have no problem. If I use the spreadsheets that already have that problem (copy rows , columns, sheets,...) from them to the new excel document , then I will have that problem. It only happens in my work computer and so far no genius could resolve it! I have a Dell mouse , zoom didn't help, pay layout didn't help, restarting excel , reinstalling the whole package (Microsoft office ) didn't help . I would think the VBA code might have some sort of problem but please , please please help if you can . It is frustrating mainly because others can't replicate it necessarily. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to automatically delete non-contiguous rows | Excel Discussion (Misc queries) | |||
How do I stop mouse from automatically selecting multiple cells | Excel Worksheet Functions | |||
Selecting a group of contiguous rows | Excel Discussion (Misc queries) | |||
Selecting a contiguous row of cells | Excel Discussion (Misc queries) | |||
How to stop Excel from automatically selecting cells? | Excel Discussion (Misc queries) |