Welcome toExcel2007.Tips.Net
Helpful Links
Beauty Tips
Legal Tips
Pest Tips
Wedding Tips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
Subscribe
Getting Rid of Insert Options
Summary: When you insert rows, columns, or cells in a worksheet, does the resulting Insert Options icon bother you? Here's how to get rid of it.Excel includes a feature that allows you to modify how you insert rows, columns, or cells in your worksheet. When you insert any of these, Excel displays a small, floating "button" right near the inserted row, column, or cell. The button, called "Insert Options," has a small paintbrush on it, similar to the Format Painter tool. Click the button, and Excel displays some options about how the inserted row, column, or cell should be formatted.
If you find the Insert Options button distracting, or if you never use it, you may want to turn it off. Follow these steps:
- Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
- At the left of the dialog box click Advanced.
- Scroll through the available options until you see the section named Cut, Copy, and Paste. (Click here to see a related figure.)
- Clear the Show Insert Options Buttons check box.
- Click on OK.
Related Tips:
More Power! For some people, the prospect of creating Word macros can be scary. WordTips: The Macros can help you conquer your fears and you'll discover you're much more confident and productive as you make Word do exactly what you want. This is an invaluable source for learning macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of WordTips. Learn at your own pace, exactly the way you want. Check out WordTips: The Macros today!