Turn on or off the message about overwriting non-blank cells

1. On the Tools menu, click Options, and then click the Edit tab.
2. To display a message, if dragging a selection or its fill handle would result in the loss of existing data, select the Alert before overwriting cells check box.

   To suppress the message, clear the check box.