When you insert a new row in a current spreadsheet, it automatically formats that row with the formatting from the line above. Is there a way of changing this so that it enters the formatting from the row below instead?
Insert Options button - which is displayed when you insert a row and the adjacent cells have different formatting - is the only mechanism that Excel provides for controlling how inserted rows are formatted.
If the button is not being displayed, activate it by clicking the
File tab on the ribbon and then clicking
Excel Options. Click the
Advanced tab, then check-mark the
Show Insert Options buttons in the
Cut, copy, and paste section and click OK.