Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Running out of room in Microsofts Checkbook Register
I downloaded the checkbook register1 template from Microsoft and am now out
of space to add anything else. I have tried to drag the columns and rows down bur nothing happens. In the Excel spreadsheet I made this works to extend the form but it will not in the one made by Microsoft. I am at a loss as to how to extend it. I have read the posts by lynnbuff and the answers to the questions, but none help. Thanks -- wilbur |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Running out of room in Microsofts 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 Thu, 2 Nov 2006 11:46:02 -0800, buck27 wrote: I downloaded the checkbook register1 template from Microsoft and am now out of space to add anything else. I have tried to drag the columns and rows down bur nothing happens. In the Excel spreadsheet I made this works to extend the form but it will not in the one made by Microsoft. I am at a loss as to how to extend it. I have read the posts by lynnbuff and the answers to the questions, but none help. Thanks Gord Dibben MS Excel MVP |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Running out of room in Microsofts Checkbook Register
"File" "New"
New workbook window opens on the right side of the sheet. Choose on my computer. Many people seem to be overwriting the Template (.xlt) instead of a copy (.xls) Lou "Gord Dibben" wrote: 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 Thu, 2 Nov 2006 11:46:02 -0800, buck27 wrote: I downloaded the checkbook register1 template from Microsoft and am now out of space to add anything else. I have tried to drag the columns and rows down bur nothing happens. In the Excel spreadsheet I made this works to extend the form but it will not in the one made by Microsoft. I am at a loss as to how to extend it. I have read the posts by lynnbuff and the answers to the questions, but none help. Thanks Gord Dibben MS Excel MVP |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Running out of room in Microsofts Checkbook Register
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checkbook register | New Users to Excel | |||
How do I get the checkbook register to keep a running balance? | Excel Worksheet Functions | |||
Checkbook Register | Excel Discussion (Misc queries) | |||
Checkbook Register template | Excel Discussion (Misc queries) | |||
how do i create a running balance on checkbook register | Excel Discussion (Misc queries) |