#1   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help adding text values Texas-DC_271 Excel Worksheet Functions 7 January 15th 05 11:14 PM
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 12:57 PM
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:17 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM


All times are GMT +1. The time now is 01:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"