I have a variety of formulas in each row that need be in any new row. Often many of the comments and values are similar as well so doing it this way saves time. The only formula that breaks using this method is the row counting formula, which is the least important. Inserting a row and using "paste special" and picking "formulas only" adds too many steps and would break the counting formula anyway.
Bookmarks