Hi John:

The excel Loan Amoritization spreadsheet goes up to 30 years. The
spreadsheet makes cells invisible through conditional formating for loans
less than 30 years. I am able to do the same thing with my spreadsheet. So I
understand the conditional formatting.

However, the Loan Amoritization Spreadsheet is able to print out only the
visible cells or rows. I can't figure out how this spreadsheet is able to
only print out the visible cells. When I print out my spreadsheet it
includes all the invisible cells or rows (made invisible through conditional
formating) in the spreadsheet along with the visible cells or rows.

I would really like to know how this is done in Excels Loan Amoritization
spreadsheet so I can incorporate it into my custom spreadsheet.

Thanks

GPIE

"John" wrote:

Excel doe not normally print hidden rows or columns, but if it does you could
select the cells you want and select 'selecteion' in the print dialogue.

What part of the Loan Amortization spreadsheet do you not understand?
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"GPIE" wrote:

I have a loan spreadsheet where I have hidden extra rows beyond the term of
the loan. I do not want these hidden rows to print.

Excel has a Loan Amortization spreadsheet that is able to do this. Does
anyone know how they did this?