Microsoft Office Tutorials and References
In Depth Information
Setting insert options
Setting insert options
When you insert columns or rows into a worksheet, Excel checks
the rows above and below or the columns to the left and right
of the insertion for any formatting that you’ve applied to those
rows or columns. If it finds any formatting, Excel displays the
Insert Options action button, which you can click to apply the
same formatting to the inserted rows or columns.
Set insert options
1 After inserting rows or columns, click the Insert Options button.
2 Select the type of formatting that you want the new cells to have.
1
2
TIP The Insert Options button appears only if the cells above
or below the insertion point have special formatting.
Search JabSto ::




Custom Search