Any way to disable to auto copying?

[kevs14]

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I like the lower right corner drag/ copy feature of excel. It's actually one of Excel's best features.
Recently I noticed, Excel will fill in every cell below of the workbook in one shot - weather I ask it to or not. So then I have to command Z and then do the drag for the 5 cells below, I wanted to drag/copy.
Any way to disable this force-fed feature? thanks!

 

[John McGhie]

Hi Kevs:

Sorry, you're going to have to describe what you have, and what you want,
more precisely. I can't guess what you're up to there.

Cheers

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
I like the lower right corner drag/ copy feature of excel. It's actually one
of Excel's best features.
Recently I noticed, Excel will fill in every cell below of the workbook in one
shot - weather I ask it to or not. So then I have to command Z and then do the
drag for the 5 cells below, I wanted to drag/copy.
Any way to disable this force-fed feature? thanks!

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]

 

[Bob Greenblatt]

I CAN'T screenshot it because the cursor to screenshot disrupts what I
need to screen shot.

John: you have a cell. THE LOWER RIGHT CORNER. That's where your cursor
(in the LOWER RIGHT CORNER OF THE CELL) turns into a JESUS CHRIST BLACK
CROSS, A BLACK CROSS that you drag downwards to copy the cell downwards
-- are you with me??????

We're with you so far. What's the question?

 

[kevs14]

I've aksed the question twice,
3rd time:
I drag down and excel fills in hundred of cellls I did not want filled.

My work around is to command Z then drag, and on 2nd time excel does not do the auto fill.

Question: how can I disable this auto-fill from the get go. thanks Bob,
thanks John, sorry for my occasional incoherence!

 

[Bob Greenblatt]

I've aksed the question twice,
3rd time:
I drag down and excel fills in hundred of cellls I did not want filled.

My work around is to command Z then drag, and on 2nd time excel does not
do the auto fill.

Question: how can I disable this auto-fill from the get go. thanks Bob,
thanks John, sorry for my occasional incoherence!

Try Excel preferences, Edit tab, and disable "enable fill handle and
cell drag and drop."

 

[kevs14]

thanks Bob,
seems to work, you don't disable it, you choose box, alert before overwriting. thanks!

 

[kevs14]

TEST, EMAIL NOTIFICATION

 

[kevs14]

Bob/ John,
I spoke to soon. It's doing doing it. And I don't want to totally diable the drag feature. But still anyway I can tell excel, that only me, and me only is the one to do the dragging?

 

[Bob Greenblatt]

Bob/ John,
I spoke to soon. It's doing doing it. And I don't want to totally diable
the drag feature. But still anyway I can tell excel, that only me, and
me only is the one to do the dragging?

Are you asking if Excel can tell who the user is? The easy answer is no.
The only way to make features user dependent is to create different user
accounts and use the judiciosly. this does not sound like something you
really want to do.