You'd want to tell your dad to uncheck it.

I didn't remember what you asked when I was typing the instructions.

Dean wrote:

Since I don't have EXCEL 2007, I can't verify, but this seems like (checking
the box) it is to allow cell drag and drop (or allow after an alert). Am I
right? What I want to do is NOT EVER allow it. The user is my elderly dad
and even the query would confuse him.

IN about six weeks, when I visit, I hope to set up a short cut for remote
assistance for the future, but I could not walk him thru it, especially
since he has bought a computer with Vista, which I hope to downgrade to XP
when I get there.

Thanks!
Dean

"Dave Peterson" wrote in message
...
Open excel
Click on the Office button (top left corner)
Click on Excel Options botton (on the bottom)
Click on the Advanced category (left hand side)
Near the top:
Editing Options Group
Look for (and check)
Enable fill handle and cell drag-and-drop
and probably(???)
Alert before overwriting cells

======
If you're both using winXP, you may want to try establishing a NetMeeting.
The
other user may be able to share his desktop and you could see everything
that he
does (right or wrong!).

Windows|Start button|Run
type:
conf
(for conference?)
and hit enter

He'll have to know your IP address to connect to you, though.
I use: http://www.whatismyip.com

=========
NetMeeting doesn't exist in Vista. But there is an option you can use:

Windows start button|Help and Support
Under the Ask for Assistance:
Invite a friend to connect to your computer with Remote Assistance

(This is available in WindowsXP, too. But I like NetMeeting better if I
can use
it.)



Dean wrote:

<< Tools Options, Edit tab, uncheck 'Allow cell drag and drop'

My dad has, without asking me, upgraded to EXCEL 2007. I need to tell
him,
over the phone, how to set this global setting in his new version EXCEL.
Can someone tell me how to do this in EXCEL 2007, so I can read it to
him,
setup by step, over the phone?

I thought I had already set this up via opening and closing macros, but
it
appears I did not, so this is a quick fix until I can visit him (he does
not
know how to undo it so, if it's still a global setting, that will do for
now).

Thanks!
Dean

"Harlan Grove" wrote in message
ups.com...
"Dean" wrote...
Perhaps I needed to be more explicit. Actually, my dad doesn't
even know how to cut and paste. But what he does know is how to
move by dragging the contents of a cell with his mouse. . . .
...
Can you help prevent that?

Tools Options, Edit tab, uncheck 'Allow cell drag and drop'.



--

Dave Peterson

--

Dave Peterson