Turn on or off the message about overwriting non-blank cells
- On the Tools menu, click Options, and then click the Edit tab.
- 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.