Fill the range j6:j14 with the formula in cell j5 to complete the amortization schedule. In excel
To fill the range J6:J14 with the formula in cell J5 in Excel, you can follow these steps:
1. Select cell J5 and copy the formula (assuming it is already correct and references the necessary cells).
2. Select the range J6:J14 where you want to fill the formula.
3. Right-click on the selected range and choose "Paste Special."
4. In the Paste Special dialog box, select "Formulas" under Paste, then hit OK.
The formula from cell J5 will now be copied and filled in the range J6:J14, completing the amortization schedule.