Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9,101
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel check register template. How to put symbol in clear column billyjpoohbah Excel Discussion (Misc queries) 1 July 26th 07 11:24 PM
How do I expand the check register template beyond 89 rows? Joe Excel Discussion (Misc queries) 2 June 5th 07 05:04 PM
Check book register template JM Hazel New Users to Excel 6 January 20th 06 01:13 AM
check register template Michele Excel Discussion (Misc queries) 3 January 19th 05 06:01 PM
Where are instructions for using Check Register template in Excel. Victoria Excel Discussion (Misc queries) 0 January 5th 05 06:19 AM


All times are GMT +1. The time now is 03:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"