Overwriting Cells

[Guest]

I cannot seem to get the "Alert Before Overwriting Cells" option to work.
Although I have the box checked I can overwrite non-empty cells without a
message. Can someone please help???

 

[Jim Rech]

That warning is only for drag and drop operations. With the option selected
make an entry in A1 and in A2. Drag A1 on top of A2. You should get a
warning.

--
Jim Rech
Excel MVP
|I cannot seem to get the "Alert Before Overwriting Cells" option to work.
| Although I have the box checked I can overwrite non-empty cells without a
| message. Can someone please help???

 

[Dave Peterson]

This message pops up if you're copying/moving a range using the mouse.

Not with ctrl-c (or ctrl-x)|ctrl-V
(or edit|copy (or cut), edit|paste)

Did you get the warning when you copied/moved via the mouse?

 

[Guest]

Even when I use the mouse to copy it or move it with the fill handle it will
just overwrite any previous information.

 

[Dave Peterson]

Using the fill handle won't cause the warning either.

But dragging the selection over a range that has stuff in it will cause the
warning to pop up.