If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|