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. |
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