ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I expand the check register template beyond 89 rows? (https://www.excelbanter.com/excel-discussion-misc-queries/145178-how-do-i-expand-check-register-template-beyond-89-rows.html)

Joe

How do I expand the check register template beyond 89 rows?
 
I love using the Checkbook Register template. However, I have now come to
the bottom of it (89th row) and there is nothing more...no alternating blue
and white spaces. I've had to create another file for the continuation...it
wuld be nice to be able to just keep all data in one file.

Thanks!!

Gord Dibben

How do I expand the check register template beyond 89 rows?
 
Joe

Make the changes to the original Template.

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 down as you wish.

Use the format painter to format the banding.

Save the template (*.xlt)


Gord Dibben MS Excel MVP

On Tue, 5 Jun 2007 00:10:01 -0700, Joe wrote:

I love using the Checkbook Register template. However, I have now come to
the bottom of it (89th row) and there is nothing more...no alternating blue
and white spaces. I've had to create another file for the continuation...it
wuld be nice to be able to just keep all data in one file.

Thanks!!



Joe

How do I expand the check register template beyond 89 rows?
 
Thanks Gord---

Perfect help...exactly what I wanted to do!!

Joe



"Gord Dibben" wrote:

Joe

Make the changes to the original Template.

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 down as you wish.

Use the format painter to format the banding.

Save the template (*.xlt)


Gord Dibben MS Excel MVP

On Tue, 5 Jun 2007 00:10:01 -0700, Joe wrote:

I love using the Checkbook Register template. However, I have now come to
the bottom of it (89th row) and there is nothing more...no alternating blue
and white spaces. I've had to create another file for the continuation...it
wuld be nice to be able to just keep all data in one file.

Thanks!!





All times are GMT +1. The time now is 11:25 PM.

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