ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do you easily add rows to check register template (https://www.excelbanter.com/excel-worksheet-functions/221758-how-do-you-easily-add-rows-check-register-template.html)

mrboard

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

joel

How do you easily add rows to check register template
 
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.
"mrboard" wrote:

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



All times are GMT +1. The time now is 02:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com