In Excel there is a feature that will allow you to modify the way in which you insert rows, columns or cells in your worksheet. When you insert any of these, Excel will display a small, button near the inserted row, column, or cell.
The button,is called called Insert Options and it has a small paintbrush on it, similar to the Format Painter tool. Click the button, and Excel will display options regarding how the row, column, or cell you inserted should be formatted.
Some folks find the Insert Options button distracting, or they never use it. If you are one of those folk, you may want to turn it off.
Follow the steps below to learn how:
- Display the Excel Options dialog box:
- In Excel 2007 click the Office button and then click Excel Options.
- In Excel 2010 display the File tab of your Ribbon and then click Options.
- At the left of the dialog box click Advanced.
- Scroll through the available options until you see the section named Cut, Copy, and Paste.
- Deselect the Show Insert Options Buttons check box.
- Click OK.