Customizing Profit & Loss Reports

You can reformat either of the P&L Reports in the MacNail construction accounting software, if you want to change the way they look. These same commands will also work on any other MacNail worksheet.

NOTE-- Goldenseal construction accounting software replaced MacNail in 2000. It's an integrated program that includes general accounting, job costing, payroll and project billing, plus estimating and other features. Reports and printed forms are very easy to change, in Goldenseal!

* To change the width of a column, click anywhere in the column, choose Column Width from the FORMAT menu, and type in a different number. Or choose Display from the OPTIONS menu, put a check next to Row and Column headings, click OK--then click on the line between headings and drag it left or right.
* To make some cells bold or italic, choose Style from the FORMAT menu (Excel 1.5) or Font from the FORMAT menu (Excel 2.2).
* To change the worksheet font, choose Font from the OPTIONS menu.
* To change the alignment of text in any of the cells, click in the desired cells and choose Alignment from the FORMAT menu.
* To put lines in the worksheet, click in the cells next to where the lines should go, and choose Borders from the FORMAT menu. Excel 2.2 also allows you to shade some cells.
* To change overall page setup, choose Page Setup from the FILE menu.