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???

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
"Keith bedford" wrote in message
...
|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???

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?

Keith bedford wrote:

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

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" wrote:

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?

Keith bedford wrote:

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

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.

Keith bedford wrote:

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" wrote:

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?

Keith bedford wrote:

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


--

Dave Peterson