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:
  1. In the Tools menu, choose Options.
  2. Select the Edit tab.
  3. Un-check the box next to "Show Insert Options buttons".
That's it -- you're free of the Insert Options buttoon forever (until you re-install Excel).

This page is powered by Blogger. Isn't yours?