[dba-Tech] A couple of Excel questions

I have a workbook containing 3 tables side by side. The range of table 1 is
A3:D15, of table 2 it's F3:F15, of table 3 it's K3:N15.

What I need to do is lose Row 3 and then insert a new row at Row 15. But
because the table has borders, what was row 15 orignally now has a bottom
edge, and the new row 15 doesn't. I know how to do a selection and kill its
formatting, and then do another selection and give it a bottom border, but
that is so clumsy.

First of all, what are commands to delete a row and to insert a row?

Second, it happens that frequently some rows in the table have not been
filled yet. In that case, I'd like to find the first blank row  and do the
row insert there, thus simplifying the the formatting code

Third, how to you copy just the value from a cell to another cell, without
copying the formatting too?

Thanks and Happy Holidays to all.
Arthur