This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Misc - Toggle Warnings on Cell Drag and Drop

If you often use Microsoft Excel 2003's cell drag-and-drop feature, depending on your configuration, when you attempt to overwrite previously-existing cells Excel displays a warning.

If this warning fails to display causing you to accidentally overwrite cells, or if you frequently use this feature and tire of the warning, it can be toggled on or off.

1. Click "Tools" - "Options".

2. When the "Options" multi-tabbed dialog box appears, click the "Edit" tab.

3. Underneath "Allow cell drag and drop", check or uncheck "Alert before overwriting cells" as desired.

4. Click "OK" to close the dialog box.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Misc - Toggle Warnings on Cell Drag and Drop.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.