automatically selecting contiguous cells - Why?

  • Thread starter Thread starter becder
  • Start date Start date
B

becder

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.
 
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
 
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!
 
Chris said:
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!
Click to expand...
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.
 
Back
Top