I have some formattings and formulas on cells of each row and I have an open
spreadsheet that can be updated by a few peoples. If someone wants to add
rows, how can the formats and formulas be retained automatically. Your
guidance is appreciated.

Thanks,

Ray