Microsoft KB Archive/247059

From BetaArchive Wiki
Knowledge Base


Works 2000: How to Modify the Standard Loan Analysis Worksheet

Article ID: 247059

Article Last Modified on 1/25/2007



APPLIES TO

  • Microsoft Works 2000 Standard Edition
  • 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.



Additional query words: w_works works2k spreadsheet mortgage

Keywords: kbhowto kbui KB247059