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

Microsoft Excel 2003 Misc - Remove Options Button After Inserting Cells

After inserting individual cells, rows, or columns in Microsoft Excel 2003 worksheets, a button with an exclamation point may appear. Clicking this button allows you to choose options such as whether or not to keep the formatting the same as previous cells or to clear formatting information from the pasted cells. While some people find this button useful, others find the exclamation point annoying. Thus, to remove this button:

1. Click "Tools", selecting "Options".

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

3. Uncheck "Show Insert Options buttons".

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 - Remove Options Button After Inserting Cells.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.