Tuesday, March 07, 2006
Excel: That annoying paintbrush button (a.k.a. "Insert Options")
Someone asked me how to get rid of the "Insert Options" button. Here's what he was getting; I've highlighted the button in this image:
You get this when you insert a row. Excel is asking what formatting you want for your new row (you can choose to copy formatting from the row above or the row below). Even when you make a choice, however, the button stays on screen, forever obscuring nearby data (you can click in another cell and the buttons stays there -- to get rid of it you have to actually edit a cell).
So, here's how to get rid of it:
You get this when you insert a row. Excel is asking what formatting you want for your new row (you can choose to copy formatting from the row above or the row below). Even when you make a choice, however, the button stays on screen, forever obscuring nearby data (you can click in another cell and the buttons stays there -- to get rid of it you have to actually edit a cell).So, here's how to get rid of it:
- In the Tools menu, choose Options.
- Select the Edit tab.
- Un-check the box next to "Show Insert Options buttons".