The Insert Options button may become available when you insert cells, rows, and columns into your worksheet. The button appears on the UI only when one or more of the following conditions are true:
The row or any cell in the row above or below the inserted row has formatting different from the default.
The column or any cell in the column to the left or right of the inserted column has formatting different from the default.
Any cell above, below, to the right, or to the left of the inserted cell or cells has formatting different from the default.
NOTE: The button does not appear when you insert copied cells.
The button appears just below and to the right of the inserted selection. When you insert rows and columns, the button may also appear below and to the right of the row or column heading.
When you click the button, you are presented with a list of options that you can apply to the inserted selection.
Bookmarks