| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check Register Balance | Excel Discussion (Misc queries) | |||
| How do I expand the checkbook register to more than 98 entries? | Excel Worksheet Functions | |||
| Check book register template | New Users to Excel | |||
| check register template | Excel Discussion (Misc queries) | |||
| Where are instructions for using Check Register template in Excel. | Excel Discussion (Misc queries) | |||
Linear Mode
