Microsoft Office Tutorials and References
In Depth Information
Setting insert options
Setting insert options
When you insert a row or column into a worksheet, Excel
examines the rows and columns surrounding the inserted element
to determine whether there is any formatting applied to those
rows or columns. If there is, you can use the controls made
available by clicking the Insert Options button to determine
what, if any, formatting is applied to your new rows or columns.
Set insert options
1 After inserting rows or columns, open the Insert Options menu.
2 Select the type of formatting that you want the new cells to have.
TIP The Insert Options indicator appears only if the cells
above or below the insertion point have special formatting.
Search JabSto ::

Custom Search