Lori Kaufman
Excel includes a feature that allows you to quickly apply some basic formatting to inserted rows, columns, or cells in your worksheet. When you insert any of these items, a small, floating button, called âInsert Optionsâ, displays next to the inserted row, column, or cell.
This âInsert Optionsâ button has a small paintbrush on it. When you click the button, Excel displays options for quickly formatting the inserted row, column, or cell. This can be handy at times, but the button might also be annoying. However, itâs easy to turn it off.
To turn off the âInsert Optionsâ button, click the âFileâ tab.
On the backstage screen, click âOptionsâ in the list of items on the left.
On the âExcel Optionsâ dialog box, click âAdvancedâ in the list of items on the left.
Scroll down to the âCut, copy, and pasteâ section on the right and select the âShow Insert Options buttonsâ check box so there is NO check mark in the box.
Click âOKâ to accept the change and close the âExcel Optionsâ dialog box.
When you turn off the âInsert Optionsâ button, you can still format the inserted row, column, or cell. Simply, select the row, column, or cell and right-click on it. A mini toolbar displays along with a popup menu. Use the mini toolbar to apply basic formatting to the item and perform other actions on the item using the popup menu.
If you turn off the âInsert Optionsâ button while an inserted row, column, or cell is still highlighted, the button still displays. The next time you insert a row, column, or cell, the âInsert Optionsâ button will not display.
