View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Mitra Mitra is offline
external usenet poster
 
Posts: 1
Default 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.