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

G

Guest

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!!
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to I expand the number of rows beyond 65536? 4
How can I lock the formatting (patterns) in Excel? 1
Check book register template 6
How do you easily add rows to check register template 1
How do I expand the checkbook register to more than 98 entries? 3
How Do I modify a downloaded template in Excel 2
Locking rows, locking columns etc like MS Excel template 2
How do I keep my row formatting when sorting data? 1

Top