Dynamic Print Area in Excel

I was creating a new version of my amortization schedule spreadsheet today and wanted to set the print area so that it didn't print a bunch of blank pages. If a person chooses a 15-year loan with monthly payments, I wanted the print area to show only those payments - not the entire table.

Square Cells in Excel

If you have done much drawing using Excel's drawing tools, you may have figured out that you can use the cells as a grid.