Turn Insert Options buttons on or off

When you select cells, rows, or columns that contain formatting, and then you insert cells, rows, or columns, the Insert Options button Button image is displayed by default. You can click this button to choose formatting options for the data that you are inserting, such as Format Same As Above, Format Same As Below, or Clear Formatting. If you don't want this button to be displayed every time that you insert formatted cells, rows, or columns, you can turn this option off.

  1. On the Tools menu, click Options.
  2. On the the Edit tab, do one of the following:
    • To turn on the Insert Options buttons, select the Show Insert Options buttons check box.
    • To turn off the Insert Options buttons, clear the Show Insert Options buttons check box.
Applies to:
Excel 2003