#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default checkbook register

I'm using the checkbook register template, and I've run out of rows--and out
of template--at about row 89. How can I extend? Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,986
Default checkbook register

If you did not download and save the template, maybe you want to do another
download and save the template in a separate file so you can add on when
needed.

"mason" wrote:

I'm using the checkbook register template, and I've run out of rows--and out
of template--at about row 89. How can I extend? Thanks!

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default checkbook register

A template creates a new workbook each time it is opened.

The original template does not get overwritten or contain data.

Why would you run out of rows in the template?

Whatever the case..................find the original template on your hard drive
and select then right-click and open.

This opens the actual template, not a new copy.

Select B89:H89 and drag/copy as far as you wish.

Use the format painter to format the banding.

Save the template (*.xlt)


Gord Dibben MS Excel MVP

On Sun, 17 Sep 2006 17:18:02 -0700, mason
wrote:

I'm using the checkbook register template, and I've run out of rows--and out
of template--at about row 89. How can I extend? Thanks!


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
checkbook register lynnbuff New Users to Excel 5 July 25th 06 08:21 PM
Checkbook Register PurpleBabs Excel Discussion (Misc queries) 5 April 26th 06 12:03 AM
Checkbook Register template PurpleBabs Excel Discussion (Misc queries) 5 April 21st 06 05:12 AM
how do i create a running balance on checkbook register mic Excel Discussion (Misc queries) 5 August 4th 05 08:53 PM
how do i add cells in checkbook register template with formulas? nlc Excel Worksheet Functions 0 June 28th 05 03:57 AM


All times are GMT +1. The time now is 09:21 PM.

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"