How do you easily add rows to check register template

[mrboard]

Had problem carring over formulas in check register template when i add rows
to the sheet.

 

[Joel]

Don't add rows to the bottom of the templete because the formulas may not get
automatically updated. Always add rows before the last row. If you need to
add a row and the bottom of the worksheet add it one row before then copy the
last row of data to the previous row and clear theh last row.

Row 10 Data A
Row 11 Data B
Row 12 Row with formulas


first Insert Row Here
Row 10 Data A
Row 11 New row
Row 12 Data B
Row 13 Row with formulas

then copy row 12 to Row 11 and add new data in row 12.