Insert rows above but keep formatting of row from below

Question

Is it possible to insert a row above a selected row but keep the formatting the same as the selected row instead of formatting row above?

Answer 1

Hi Terri,

When you insert a row or a set of rows, the existing rows below the insertion point are shifted down, and you receive the following set of options:

• Format Same as Above: Applies formatting to the inserted row to match the format of the rows above.
• Format Same as Below: Applies formatting to the inserted row to match the format of the rows below.
• Clear Formatting: Clears all formatting.

Reference: How to use the "Insert Options" button in Excel

You can first insert the row above and then click the Insert Options button and choose Format Same as Below.

Thanks,

Neha

Answer 2

Hi Terri,

Did you check the above reply? Please let us know if you need further help.

Regards,

Neha

Answer 3

I'm not sure about that, but the Format Painter allows you to copy a whole row's formatting and apply to another row.