Hi Marilyn,
I don't know where you saw a setting "Format as Above"
(I have Excel 2002), but to do what you want see
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

The macro will copy the row you are on, inserting the
number of rows you request in the dialog reply below the
current row. So you will have the same formatting. The
macro retains only the formulas for the insert rows by removing
the constants from the inserted rows.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Marilyn" wrote
I have a workbook where I have Columns F2:K2 merged I also have the same
columns merged for rows 3, 4, 5, 6, and 7. When I insert a new row in that
area I choose to "Format Same as above" however, the cells in columns F:K are
not merged like the ohers. I would like the new inserted rows to have merge
cells from columns F:K.