Works 2000: How to Modify the Standard Loan Analysis Worksheet (247059)


The information in this article applies to:

  • Microsoft Works 2000
  • Microsoft Works Suite 2000
This article was previously published under Q247059

SYMPTOMS

In Microsoft Works 2000, the Standard Loan Analysis Financial Worksheet only shows the amortization of the loan over 11 payment periods.

STATUS

This behavior is by design.

MORE INFORMATION

You can use the Fill Down option to modify this report for any loan term you want. To do this:
  1. Highlight to select the bottom row of data in the worksheet and the empty row beneath it.
  2. Click Edit, and then click Fill Down.
  3. Repeat steps 1 and 2 for each additional payment period you want to display on the worksheet.
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbhowto kbui KB247059
©2004 Microsoft Corporation. All rights reserved.